Does DBMS_JOB recompute the NEXT_DATE interval after or before

Posted on By Admin No Comments on Does DBMS_JOB recompute the NEXT_DATE interval after or before

goal: Does DBMS_JOB recompute the NEXT_DATE interval after or before executing the procedure or job? fact: PL/SQL fix: The NEXT_DATE is computed AFTER the job gets executed successfully. The INTERVAL date function is evaluated immediately before a job is executed. If the job completes successfully, the date calculated from INTERVAL becomes the new NEXT_DATE. If…

Read More “Does DBMS_JOB recompute the NEXT_DATE interval after or before” »

Oracle, SQL scripts

Committing distributed transaction using commit force

Posted on By Admin No Comments on Committing distributed transaction using commit force

Committing Using Only the Transaction ID The following SQL statement commits an in-doubt transaction: COMMIT FORCE ‘transaction_id’; The variable transaction_id is the identifier of the transaction as specified in either the LOCAL_TRAN_ID or GLOBAL_TRAN_ID columns of the DBA_2PC_PENDING data dictionary view. For example, assume that you query DBA_2PC_PENDING and determine that LOCAL_TRAN_ID for a distributed…

Read More “Committing distributed transaction using commit force” »

Oracle, SQL scripts

Rollback force for distributed transactions

Posted on By Admin No Comments on Rollback force for distributed transactions

FORCE Clause Specify FORCE to manually roll back an in-doubt distributed transaction. The transaction is identified by the text containing its local or global transaction ID. To find the IDs of such transactions, query the data dictionary view DBA_2PC_PENDING. A ROLLBACK statement with a FORCE clause rolls back only the specified transaction. Such a statement…

Read More “Rollback force for distributed transactions” »

Oracle, SQL scripts

Sending email with file attachment.

Posted on By Admin No Comments on Sending email with file attachment.

Single File Attachemnt: ======================= cat test.dat|uuencode test.dat|mailx -s “subject” mailid Multiple file Attachment: ========================= (uuencode INPUTFILE $FILE_STRING.out ;uuencode INPUTFILE $FILE_STRING.err )|mailx -s “SUBJECT” $EMAIL_ID (uuencode INPUTFILE check_dr_notok.log ;uuencode INPUTFILE check_dr_ok.log )|mailx -s “Test multuple attachment” pmehta@1800flowers.com (uuencode check_dr_notok.log check_dr_notok.log ;uuencode check_dr_ok.log check_dr_notok.log)|mailx -s “Test multuple attachment” pmehta@1800flowers.com

Linux/Unix, shell

Kernel Parameters for Solaris

Posted on By Admin No Comments on Kernel Parameters for Solaris

* pre Solaris 10 * ——————- To view the current values of these parameters, enter the following commands: # grep noexec_user_stack /etc/system # /usr/sbin/sysdef | grep SEM # /usr/sbin/sysdef | grep SHM * Post Solaris 10 * =================== In Solaris 10, you are not required to make changes to the /etc/system file to implement the…

Read More “Kernel Parameters for Solaris” »

Linux/Unix, shell

Physical Standby switchover with session active

Posted on By Admin No Comments on Physical Standby switchover with session active

In order to perform a switchover all sessions to the database need to be disconnected. In version 901 this was a manual process. In version 9.2.0 this process has been automated with the “with session shutdown” clause that has been added to the alter database commit to switchover command. If SWITCHOVER_STATUS returns SESSIONS ACTIVE then…

Read More “Physical Standby switchover with session active” »

Oracle, rman-dataguard