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.......
guy harrison's book
oracle sql high-performance tuning is a very good book
i am reading it now.
guru is on the way!!!!
The Oracle Performance Tuning manual is a good place to start. Go to the following URL
Oracle8i Designing and Tuning for Performance
OCP 8i, 9i DBA
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.
Life is a journey, not a destination!
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...
Performance... Push the envelope!
And not forgetting autotrace.
As the user, you'll need to run the
Then, you'll need to run the plustrce.sql as the SYS user
Then before you run you statement,
SQL> set autotrace on
OCP 8i, 9i DBA
Click Here to Expand Forum to Full Width