new dba routine
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: new dba routine

  1. #1
    Join Date
    Aug 2000
    Posts
    163

    Cool

    Hello,
    I got to the point where I don't have urgent problems with my db. I think we got a lot of problems under control(space management and allocation next extents).
    Now I am wondering what else I can be doing and checking to get my database in a helphier mode.
    Expirienced dba's, please let me know what rouitine maintenance tasks you perform or what would be some of the other things I can work on.
    Thank you.

  2. #2
    Join Date
    Nov 2000
    Posts
    344
    Every day I check basic tuning parameters like buffer cache hit ratio, library cache hit ratio, etc, and also I check for tablespaces running out of room, objects which are unable to extend, tablespace fragmentation, and things like this.
    Also, I check alert logs for errors. Some of these things actually get checked more than once a day...

    Once a week I run a script which does an 'alter index blah validate structure' to check for indexes which are ready for a rebuild, and I rebuild the onces that need it.


  3. #3
    Join Date
    Nov 2000
    Posts
    344
    Oh yeah, for the databases that are using the COST based optimizer, I gather statistics on my tables periodically (more often for changing databases, less often for those that don't change so much)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width