Re: Help a newbie trying to learn PL/SQL - No trace is showing up

"Keld Nielsen" <keldnielsen_at_tiscali.you.know.dk> wrote in message news:3f316a5c$0$32495$edfadb0f_at_dread16.news.tele.dk...
>
> "Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message
> news:1060199782.580167_at_yasure...
> > Keld Nielsen wrote:
> >
> > >"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message
> > >news:lKYXa.37861$Ne.17172_at_fed1read03...
> > >
> > >
> > >>tk wrote:
> > >>
> > >>
> > >>>Hi Folks:
> > >>>
> > >>>I'm doing the examples on p.126/127 of the Oracle 8i Advanced PL/SQL
> > >>>programming book. I have 9i installed so I am not sure if this
makes
> a
> > >>>difference. Mind you, I've only been doing this since Thursday of
> last
> > >>>week so I am VERY new to this and a moron.
> > >>>
> > >>>I created a user and have issued the following thru SQLPLUS
> > >>>--
> > >>>ALTER SESSION SET EVENTS '10938 trace name context level 10';
> > >>>
> > >>>ALTER PROCEDURE RaiseIt COMPILE DEBUG;
> > >>>
> > >>>-- Anonymous block which raises some exceptions.
> > >>>BEGIN
> > >>> CallRaise(1001);
> > >>> RaiseIt(-1);
> > >>>END;
> > >>>/
> > >>>--
> > >>>
> > >>>Then I go to the udump directory and examine the trace file and do
> *not*
> > >>>receive the stack trace like the book says I should. Rather I see
the
> > >>>following in the trace file... Am I missing some type of
> > >>>
> > >>>
> > >setting/option in
> > >
> > >
> > >>>order to see the same call-stack trace that the book says I should
> > >>>
> > >>>
> > >see???
> > >
> > >
> > >>>I don't see any callstack trace in this trace file... Although, I
can
> > >>>query the sys.plsql_trace_events and the sys.plsql_trace_runs table
and
> > >>>
> > >>>
> > >see
> > >
> > >
> > >>>data in it. I just don't see it echoed to the following trace file.
> > >>>
> > >>>thanks in advance, Theron
> > >>>
> > >>>
> > >>>
> > >>>
> >
>
>===========================================================================
> =
> > >
> > >
> > >>>==========================
> > >>>
> > >>>Dump file c:\oracle\admin\therons\udump\therons_ora_480.trc
> > >>>Tue Aug 05 19:47:14 2003
> > >>>ORACLE V9.2.0.1.0 - Production vsnsta=0
> > >>>vsnsql=12 vsnxtr=3
> > >>>Windows 2000 Version 5.0 Service Pack 2, CPU type 586
> > >>>Personal Oracle9i Release 9.2.0.1.0 - Production
> > >>>With the Partitioning, OLAP and Oracle Data Mining options
> > >>>JServer Release 9.2.0.1.0 - Production
> > >>>Windows 2000 Version 5.0 Service Pack 2, CPU type 586
> > >>>Instance name: therons
> > >>>
> > >>>Redo thread mounted by this instance: 1
> > >>>
> > >>>Oracle process number: 12
> > >>>
> > >>>Windows thread id: 480, image: ORACLE.EXE
> > >>>
> > >>>
> > >>>*** 2003-08-05 19:47:14.000
> > >>>*** SESSION ID:(10.229) 2003-08-05 19:47:14.000
> > >>>--NOTICE ---------------------------------------
> > >>>--PL/SQL TRACE INFORMATION IS NOW IN THE DATABASE
> > >>>-- To create the trace tables, use the script --
> > >>>-- rdbms/admin/tracetab.sql under ORACLE_HOME --
> > >>>
> > >>>
> > >>>
> > >>>
> > >>The book is out of date.
> > >> From SQL*PLUS do:
> > >>SQL> @rdbms/admin/tracetab.sql
> > >>
> > >>
> > >
> > >wrong ! it's in ORACLE_HOME ... etc as clearly stated in the
> > >OP's mail - or can't you read ?
> > >
> > >
> > >
> > >>PLEASE try to UNDERSTAND the contents of the trace file!
> > >>
> > >>
> > >
> > >any reason to yell ? The contents of the file ? As you give the
> impression
> > >that you know, would you care to share ?
> > >
> > >
> > >
> > >>With 9i the results are placed inside the DB & NOT in a trace file.
> > >>
> > >>
> > >>
> > >Oh, we don't have a choice anymore !!
> > >
> > >
> > >
> > Trace files are still put into UDUMP just as always if you follow the
> > directions.
> >
>
> Quite right, I was just trying point to excatly that in reply to
> "With 9i the results are placed inside the DB & NOT in a trace file"
>

eeh, 'I just tried to point to exactly ...' sorry !

> Best regards,
> Keld
>
> > --
> > 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)
> >
>
>
Received on Wed Aug 06 2003 - 16:03:52 CDT