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

    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.

    Cheers
    E
    Cheers
    Etravels

  2. #2
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246
    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.
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

  3. #3
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    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 http://asktom.oracle.com 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
  •