Kamran Agayev's Oracle Blog

Oracle Certified Master

Archive for June, 2009

Storing or NOT Storing files in an Oracle Database

Posted by Kamran Agayev A. on 30th June 2009

Here, you can find a good discussion and suggestion from Tom Kyte about “Storing files in an Oracle Database”.

Before reading this article, I was thinking to store OS files on another OS location. But Tom’s approach is different (as usual) and logical :)

I assume that this article will be useful for you, thus sharing it with you

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1011065100346196442

Posted in Administration | No Comments »

Committing Transaction

Posted by Kamran Agayev A. on 27th June 2009

A good research made by Oracle Master – Laurent Schneider on “Committing Transaction”

Posted in Administration | No Comments »

A Good time to be an Oracle DBA – CNN research

Posted by Kamran Agayev A. on 25th June 2009

Recently I’ve seen a very interesting article posted by Mr. Paul Sorensen in general Oracle Blog. This article was about CNN research on “Ten promising jobs for class of 2009“. I suggest you to read this post and be proud of your career choice :)

A Good Time To Be an Oracle DBA

Posted in Administration | No Comments »

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 »