Re: Statspack and Enqueue wait times

Richard Foote wrote:

> "Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message
> news:3EF9CF1E.AF8E4E1D_at_exxesolutions.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/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)