DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: DBMS_SUPPORT.START_TRACE_IN_SESSION

  1. #1
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    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."

  2. #2
    Join Date
    Nov 2000
    Posts
    344
    Do you mean

    DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION?

    -John

  3. #3
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    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

  4. #4
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    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
  •  


Click Here to Expand Forum to Full Width