Re: Statspack ratios help

From: Terry Sutton <terrysutton_at_usa.net>
Date: Thu, 8 Jun 2006 15:48:56 -0700
Message-ID: <044b01c68b4e$6bd3cb30$6400a8c0@TerrySutton>

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jun 08 2006 - 17:48:56 CDT