Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Help a newbie trying to learn PL/SQL - No trace is showing up
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;
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
![]() |
![]() |