Shailesh wrote:
> 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
Take a look at the DBMS_PROFILER built-in package. It seems it is what
you want. There is a demo in Morgan's Library at www.psoug.org.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Fri Apr 07 2006 - 11:19:40 CDT
