DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Sql Tuning

  1. #1
    Join Date
    Oct 2002
    Posts
    43

    Sql Tuning

    Hi all,
    can anyone tell me some good sites for getting knowledge in Tuning the SQL Queries..
    thanx in advance..
    Pratheesh

  2. #2
    Join Date
    Jul 2000
    Posts
    119
    I think it all will start from identifying your sql queries you want to tune first..search this site for top sql and you will find many..
    OCP 8.0, 8i, 9i

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    go to tahiti.oracle.com and read performance tuning guide chapter 5 to 10 or so

  4. #4
    Join Date
    Oct 2002
    Posts
    43
    Originally posted by launchpad
    I think it all will start from identifying your sql queries you want to tune first..search this site for top sql and you will find many..
    Sorry tell me the exact one
    Prathesh

  5. #5
    Join Date
    Jul 2000
    Posts
    119
    okay, to start tuning SQL, you should first have SQL to tune in hand.
    How do I get it ?
    check from v$sqlarea, which sql statements are doing lots of logical reads and physical reads.
    Run statspack report which will give you resource comsuming SQL's.
    Once you have got the SQL's check the explain plan and try to find out why the sql is taking time.
    Check data destribution to find out what's bottleneck.
    Ensure database is gathering statsistics on regular basis.
    These are really very general things to satrt with, but worth following!
    OCP 8.0, 8i, 9i

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