SQL TUNING
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: SQL TUNING

  1. #1
    Join Date
    Feb 2001
    Posts
    82
    Is there anyone who can give me reading materials on how tune a sql statement (procedure/packages/functions/triggers).
    good points and bad points...

    any help would be very much appreciated.......

  2. #2
    Join Date
    Jun 2001
    Posts
    193
    guy harrison's book
    oracle sql high-performance tuning is a very good book
    i am reading it now.
    guru is on the way!!!!

  3. #3
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    The Oracle Performance Tuning manual is a good place to start. Go to the following URL

    http://oradoc.photo.net/

    Oracle8i Designing and Tuning for Performance

    Cheers,

    OCP 8i, 9i DBA
    Brisbane Australia

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Looking for the best book. buy the Tomas Kytes Expert one on one Oracle.

    I have just started reading this, find it quit interesting. Comparisons are simple and to the point.

    Good book!

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Aug 2001
    Posts
    111
    Don't dismiss the Oracle documentation too. Is it much better than previous versions.
    Nothing like using EXPLAIN PLAN and TKPROF... whoops i am showing my age as a dba.

    If you are using 8i there is an internal package DBMS_PROFILER which will help heaps to timing procedures and functions and finding bottlenecks.
    Benchmark the existing process before proceeding to tune. That way you know where to go first (to bottlenecks) and spend time improving code where you will get the greatest return for time spent.

    Check out Steve Adam's site as well. It expanded my mind...

    Have Fun
    Performance... Push the envelope!

  6. #6
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    And not forgetting autotrace.

    As the user, you'll need to run the

    $ORACLE_HOME/rdbms/admin/utlxplan.sql

    Then, you'll need to run the plustrce.sql as the SYS user

    $ORACLE_HOME/sqlplus/admin

    Then before you run you statement,

    SQL> set autotrace on

    Cheers,
    OCP 8i, 9i DBA
    Brisbane Australia

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