Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004

    Unanswered: Best Approach for Tuning an Oracle DB9i

    hello all

    I have just started a new job and they have asked me to set out a plan to tune the databases and the best method for Performance & optimisation of all the databases:

    Where do I start in relation to the databases: I am using Oracle Enterprise Manager (oracle dba studio if using 8i) and want to know where to start? I am reading lots of books etc for info but does anyone know where I should start and if there is a quick approach to this?
    The database design are already set up with the appropiate table spaces, datafiles & control files.


  2. #2
    Join Date
    Sep 2003
    Virginia, USA
    It sounds like you need a lot more info. Way too much to put here. Look for books by Tom Kyte and others on the subject, and checkout the OCP study guide #4 which is the "performance tuning" exam.
    Author, Oracle Database 10g: From Nuts to Soup

  3. #3
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    >they have asked me to set out a plan to tune the databases
    Tune what is slow.
    get book "Optimizing Oracle Performance" by Cary Milsap & Jeff Holt
    get book "Expert One-on-One Oracle" by Tom Kyte
    visit for many, many GREAT examples
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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