Is it possible to use combination of DBMS_TRACE and Session Trace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Is it possible to use combination of DBMS_TRACE and Session Trace

  1. #1
    Join Date
    Jul 2000
    Location
    Pune, India
    Posts
    80

    Is it possible to use combination of DBMS_TRACE and Session Trace

    Hello,

    We use DBMS_TRACE, but currently I am finding few limitations for the same, please le us know if there is way out.

    DBMS_TRACE shows output in SYS.PLSQL_TRACE_EVENTS table and it helps me to know
    how many triggers, procedures are invoked by my DML statements. As there are
    hundreds of Procedures, Triggers in our application it would be better if I get
    output as shown below...

    Source Statement:
    UPDATE TableName SET ColumnName = :1 WHERE ROWID = :2

    Trigger: TrgRow_1

    Procedure: Pro_1
    SELECT ....
    INSERT ....

    Procedure: Pro_2
    UPDATE
    SELECT

    This helps me to identify Statements related to corresponding Procedures or
    triggers. Currently We tried to club and ,
    but still doesn't get output as shown above.

    Please help.

    Thanks & Regards,

    Shailesh

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Why don't you try to use PL/SQL profiler?

    http://beaconinfotechcorp.com/art_005.html

    Tamil

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