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

From: tk <theronk_at_charter.net>
Date: Tue, 5 Aug 2003 21:17:22 -0600
Message-ID: <vj0ovj57um481b@corp.supernews.com>

> The book is out of date.
> From SQL*PLUS do:
> SQL> @rdbms/admin/tracetab.sql

Thank you so much for telling me that. I thought I was doing something wrong!!!

> PLEASE try to UNDERSTAND the contents of the trace file!
> With 9i the results are placed inside the DB & NOT in a trace file.

Oh I understand basically what it's saying. I'm a long time systems programmer in C/C++/Java and have had to go thru many a stack trace/dump. The oracle one is no different. I was just scratching my head when the contents of the file did not agree with what the book said.

---

By the way, I tried running the @rdbms/admin/tracetab.sql and got a not found error... The output follows (I'm not sure what I'm doing wrong)

SQL> ALTER SESSION SET EVENTS '10938 trace name context level 5';

Session altered.

SQL>
SQL> -- Anonymous block which raises some exceptions.
SQL> BEGIN

  2 CallRaise(1001);
  3 RaiseIt(-1);
  4 END;
  5 /
BEGIN
*
ERROR at line 1:

ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "TKOUSEK.RAISEIT", line 7
ORA-06512: at line 3

SQL> @rdbms/admin/tracetab.sql
SP2-0310: unable to open file "rdbms/admin/tracetab.sql" Received on Tue Aug 05 2003 - 22:17:22 CDT