Database Administrator Regular Tasks
An Oracle DBA has to pro-actively and sometimes reactivly monitor databases so that all the applications and database in general remain healthy and performs optimally.
These DBA activities are periodic i.e. can be split into daily, weekly, monthly etc activities. Some of these activities include the following -
- Making sure different Oracle server directories like bdump, udump etc are kept in check.
- Backup and archive listener alert log file to keep it's growth in check.
- Keeping your database (and hence objects sizes) in check using object shrinking, reorganizing, rebuilding indexes online etc.
- Checking what is going on in database at the moment, in order to diagnose an issue.
- Identifying top resource consumers e.g. CPU, disk, parsing etc. (i.e. faulty SQL's).
- Displaying Oracle memory consumption and hence identfifying bottlenecks and amending them.
- .... etc. etc.
This note discusses step by step way to perform some of essential oracle dba periodic activities includings SQL scripts or shell scripts required to perform them.
Our personal notes provide you very clear, step by step instructions. Note that we use these notes only to do our normal periodic DBA activities, so it really works!
| Google best Oracle sites right from here > |
Go to the next page and you can see our entire catalogue of Database Study material list