Kamran Agayev's Oracle Blog

Oracle Certified Master

Archive for June 10th, 2009

DBA_SCHEDULER_JOB_LOG

Posted by Kamran Agayev A. on 10th June 2009

The dba_scheduler_job_log view can be used to view log entries for previously executed jobs. This view displays log information for all dbms_scheduler jobs in the database. When creating a job, we define log_history parameter and logs in that view are available for number of days as it specified in log_history parameter (default is 30)

To read full article, refer to this link

Posted in Administration | 2 Comments »

Tracking & auditing changes to your init.ora parameters

Posted by Kamran Agayev A. on 10th June 2009

A very important auditing task for any production database is the ability to track changes to the powerful initialization parameters. Many of these parameters are “silver bullets”, single parameters that have a profound impact on system-wide behavior. This is especially true for SQL optimizer changes

To read full article, refer to this link

Posted in Administration | No Comments »