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 »
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 »
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 »
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 »
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 »