-
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?
"High Salaries = Happiness = Project Success."
-
Do you mean
DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION?
-John
-
dbmsutil.sql
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
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|