Statspack and Enqueue wait times

#11

Richard Foote wrote:

Quote:

"Daniel Morgan" <damorgan (AT) exxesolutions (DOT) com> wrote in message
news:3EF9CF1E.AF8E4E1D (AT) exxesolutions (DOT) com...

Looking for a good source I can point my students to with respect to
tracing.
Something more tutorial with step-by-step than the standard otn documents.

Any suggestions will be appreciated.

Hi Daniel,

Metalink has a number of notes with regarding to tracing to get you started.
These include:

Note: 21154.1 Event 10046 enable SQL statement tracing
Note: 39817.1 Interpreting RAW 10046 output

There are also some excellent articles by Cary Millsap and Jeff Holt on
their Hotsos site (www.hotsos.com)

Steve Adams as usual has lots on good stuff on tracing (www.ixora.com.au)

Then there's what's in my head but I fear your students might be traumatised
by what else they might find in there ...

Cheers

Richard

Once again thanks but it is not a source I can properly make accessible to
students and it would violate Oracle's
license terms to copy the material for students.

I use these sources, myself, to prepare materials, but would really like a
publicly accessible source of this material (and previously unstated ... without
having to invest the time to build it myself). Perhaps I will have to invest the
time a do
my own treatment of the material.

Thanks again.
--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Statspack and Enqueue wait times

comp.databases.oracle.server comp.databases.oracle.server

Re: Statspack and Enqueue wait times - 06-26-2003 , 11:02 AM