Hello on 8.0.5 I want to run DBMS_SUPPORT.START_TRACE_IN_SESSION to trace a session. I cant find that package in dba_objects. What do i have to do to get tthat package?
Printable View
Hello on 8.0.5 I want to run DBMS_SUPPORT.START_TRACE_IN_SESSION to trace a session. I cant find that package in dba_objects. What do i have to do to get tthat package?
Do you mean
DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION?
-John
Hi, 24th April 2001 22:18 hrs chennai
If you are right on DBMS_SYSTEM then execute the following script called DBMSUTIL.sql found in the path which creates
dbms_system package.
cheers
padmam
I think what the original poster want is to use the DBMS_SUPPORT package functions, this way :
sys@prod::SQL>desc dbms_support.start_trace_in_session
PROCEDURE dbms_support.start_trace_in_session
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
SID NUMBER IN
SERIAL NUMBER IN
WAITS BOOLEAN IN DEFAULT
BINDS BOOLEAN IN DEFAULT
sys@prod::SQL>
See, in Oracle 7.3.4 (but not in all platforms) Oracle give to you a script to build the DBMS_SUPPORT package (useful to trace session with waits info and bind vars without oradebug, and without the PID).
In 8.X the script is gone, but it can be requisited from Oracle, or you can use the same version present in 7.3.4 database - I did it with 8i and 8.0.x).
Regards,
Chiappa