SQL TUNING

[antonv]

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.......

[beginner]

guy harrison's book
oracle sql high-performance tuning is a very good book
i am reading it now.

[grjohnson]

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,

[sambavan]

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

[roobaron]

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

[grjohnson]

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,