"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message
news:E2F6A70FE45242488C865C3BC1245DA703D5CA89_at_lnewton.leeds.lfs.co.uk...
> Hi Daniel,
>
> Tom Kyte's oft recommended book has an excellent chapter on tracing
> using SQL_TRACE, TKPROFF and 10046 events. Most entertaining and
> enlightening. It worked for me.
>
> Unfortunately, I'm not withing 20 miles of said book (it's at home) so I
> can't give you chapter and verse I'm afraid.
>
> Cheers,
> Norman.
>
> PS. Its the Oracle 101 book !
> PPS. It's on Wrox :o(
>
>
>
> -----Original Message-----
> From: Daniel Morgan [mailto:damorgan_at_exxesolutions.com]
> Posted At: Wednesday, June 25, 2003 5:35 PM
> Posted To: server
> Conversation: Statspack and Enqueue wait times
> Subject: Re: Statspack and Enqueue wait times
>
>
> 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.
> --
> 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)
>
Chapter 10. DBMS_PROFILER is also covered in the same chapter.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Thu Jun 26 2003 - 07:26:11 CDT
