Sunday, January 20, 2008
Regular Tasks Of a DBA....
1.Regular Monitoring of The free space in Database.
2.Taking logical bakups of important table.
3.Checking the locks on the Database.
4.Checking the long running queries on ur database
5.Analysing the performance of ur Database
6.Investigate Wait Statistics
8.Ensure Connectivity to Oracle
13.Check if all the instances are up and running ps -ef | grep ora -
14.check if all the listeners are up and running ps -ef | grep litener
15.check log file for any new errors
16.verify success of backup
18.verify size of archived folder
19.check out free space of tablespace
20.check invalid objects
21.monitor users and transactions for dead locks
22.Monitoring the Top SQL Statements
23.Monitoring Long Operations
25.Monitoring System Statistics
26.Is the database up and responding to requests
27.Are the listeners up and responding to requests
28.Are the Oracle Names and LDAP Servers up and responding to requests
29.Are the Web Listeners up and responding to requests