-
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
http://oradoc.photo.net/
Oracle8i Designing and Tuning for Performance
Cheers,
OCP 8i, 9i DBA
Brisbane Australia
-
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!
-
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!
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|