This content has been marked as final. Show 13 replies
first step, read documentation should help:
and close your threads:
shiva_oracle Handle: shiva_oracle Status Level: Newbie Registered: May 27, 2011 Total Posts: 8 Total Questions: 5 (4 unresolved) Name Shiva Location Bangalore Occupation Software Engineer Biography Worked on Technologies Oracle DBA, PLSQL,SQL, Oracle Forms 11g, Oracle Reports 11g, Oracle ADF, Linux
check ora errors coming in alert log file....
alert log is cronical log for you database activities...it contains information about the activities performed in database.....
you can schedule a purge job for oracle alert log file or you can use ADRCI tool to manage oracle alert log....
and do read the book provided by Fran..its basics of database architecture helps you to understand your dba activities.....
Edited by: Niket Kumar on Jan 23, 2013 2:14 PM
Reading these documentations is ok.. but we cant install software , configure network, perform recovery, etc on daily basis right.
I want the activities performed on production database daily.
@Fran, Its absolutely not necessary to post profile. If you wanna help, just answer the question and gain points.
shiva_oracle wrote:1) get a cup of coffee
what are the daily activities that are performed by you in a production database.
Please mention the list,so that it helps me perform on my own database.
2) read the OTN forums
3) check email for any alerts that were detected in the databases.
4) get another cup of coffee
5) check that my overnight backup jobs ran
6) check and record disk usage
7) get another cup of coffee
8) exchange pleasantries with people in neighboring cubicles.
9) deal with anything that has come up in steps 1 through 8
10) project work.
I used to worry about the same questions you asked. Eventually I realized that if one follows best practices, Oracle databases pretty well take care of themselves. If I make sure they have enough disk space, my backups are running, the alert log is clean of 'ora-' messages, and my phone isn't ringing, I can drink a lot of coffee and flirt with the secretary.
Edited by: EdStevens on Jan 23, 2013 6:45 AM
Most of my day is taken up with preventing users from causing problems. I found the very best way to do that is to lock out all the user accounts from every single database (including 'their' test databases) and route all my calls to voicemail. I do believe my mailbox is full but I haven't listened to a single complaint and the databases are running better than ever - no need to worry about changing execution plans or query tuning.
Problems with databases are almost all caused by users - remove users from the equation and sunshine will fill your days and calm will fill your nights.