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