Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

Re: Statspack ratios help

Terry Sutton

2006-06-08

Replies:

As others have suggested, Cary's book it the most thorough treatment of profiling.
 
For shorter, less thorough, articles (which you could read in an afternoon, just to get started), google for articles describing the use of tkprof.  Below are links to some articles authored by colleagues of mine:
 
http://www.dbspecialists.com/presentations.html#explain_and_tkprof
http://www.dbspecialists.com/presentations.html#wait_events
http://www.dbspecialists.com/presentations.html#wait_events2
 
tkprof is not as nice as Hotsos's Profiler, but it comes with Oracle, and it's a good way to get started.
 
--Terry
Can you suggest some books and other resources to learn about
profiling.
 
Thanks
 
Joseph Amalraj

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.