Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!crtntx1-snh1.gtei.net!nycmny1-snh1.gtei.net!news.gtei.net!newsfeed!lon-transit.news.telstra.net!news.telstra.net!newsfeeds.bigpond.com!not-for-mail From: "Richard Foote" Newsgroups: comp.databases.oracle.server References: <7a58b2f6.0306241007.5608970b@posting.google.com> <3EF89A3F.4E206DC7@remove_spam.peasland.com> <3EF9CF1E.AF8E4E1D@exxesolutions.com> Subject: Re: Statspack and Enqueue wait times Lines: 31 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2720.3000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-ID: Date: Thu, 26 Jun 2003 22:44:08 +1000 NNTP-Posting-Host: 144.139.225.93 X-Trace: newsfeeds.bigpond.com 1056630156 144.139.225.93 (Thu, 26 Jun 2003 22:22:36 EST) NNTP-Posting-Date: Thu, 26 Jun 2003 22:22:36 EST Organization: Telstra BigPond Internet Services (http://www.bigpond.com) Xref: core-easynews comp.databases.oracle.server:191250 X-Received-Date: Thu, 26 Jun 2003 05:35:19 MST (news.easynews.com) "Daniel Morgan" wrote in message news:3EF9CF1E.AF8E4E1D@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