Re: regular maintenance jobs!!

From: Shreepad Vaidya <Shreepad.Vaidya_at_alltel.com>
Date: Wed, 18 Oct 2000 1:15 -0500
Message-Id: <10652.119592@fatcity.com>

Hi Dulce,
Some of your daily tasks could be.

1) Check if your instances are up.
2) Check your alert logs.
3) Check the status of your listener process.
4) Check the listener and sqlnet logs.
5) Check the user dump destinations , core dump destinations

,background dump destinations.
6) Check the status of archiving , especially check if the archive destination has sufficient free space.

7) Check for the free space in all tablespaces.
8) Check for fragmentation in tablespaces.
9) Check for various hit ratios(e.g: --database buffer,dictionary,row

cache).
10) Check the status of your backups (online , export etc..........) . Ensure that the destination directory has sufficient free space.
11) Check the status of objects in your database.(triggers,procedures etc..) Ensure that they are valid.
12) Monitor the tables which show high growth . ( This could be through a script) .
13) Analyze tables ( may not be all tables ,but some selected tables). Generate histograms whereever and whenever necessary.

14) If auditing is on check the corresponding tables . Purge regularly
15) Check for contention . (Rollback , latches )
16) Change DBA passwords regularly .
17) Check your $ORACLE_HOME/rdbms/audit directory . This will contain

a log file whenever you connect as internal /system (especially during shutdown and startup).

18) Check stagnation of indexes.
19) Keep a track of no of users/sesions connecting to database.
20) Test your backup strategy by doing a dry run recovery at least

once a week.

P.S: If posible visit technet site to keep a track of happenings .

HTH Received on Wed Oct 18 2000 - 01:15:34 CDT