DB Health Check
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: DB Health Check

  1. #1
    Join Date
    Dec 2001
    Posts
    337

    DB Health Check

    Hi all,

    I have to give a customers db a 'once over' tomorrow just to give them an idea that all the settings they have set are ok. Does anyone have a broad overview of what one should look at to provide a 'health cheack' for a 10g db? At a glance I would look at:

    init.ora (memory settings and all)
    check if archiving is on
    check if a backup strategy is in place
    check if all dbfs/control files are placed correctly
    check if segments placed in the right areas

    They are going are using partioning ( i have little experiance of this ), is there any thing i need to look at for this?

    Any more ideas will be greatly appreciated!

    Thanks,
    Chucksk

  2. #2
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    check first if the have a good server configuration the applications that will run against it and the number of users
    Behind The Success And Failure Of A Man Is A Woman

  3. #3
    Join Date
    Feb 2003
    Posts
    63
    Run statspack to gather performance snapshots through out the day

    as well as backup strategy do they test restores, some places have great docs etc about backing up the database but never test restores!!!

  4. #4
    Join Date
    Dec 2001
    Posts
    337
    Thanks Craig. Yes I forgot to mention statspack as well. The will be one of the key things!

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