Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 <sys.plsql_trace_events> and
<user_source>,
but still doesn't get output as shown above.
Please help.
Thanks & Regards,
Shailesh Received on Fri Apr 07 2006 - 04:26:39 CDT