Re: tracing pl/sql calls for a running application.

"James A. Williams" <willjamu_at_mindspring.com> wrote in message news:3c62ba94.17284974_at_news.mindspring.com...
> I have inherited a large application with hundreds of packages and
> procedures.
>
> I would like to run the app and then obtain a report of each procedure
> called and who called it. That is all.
>
> I have found the ' ALTER SESSION SET EVENTS '10928 trace name context
> level 1' call but this thing produces to much data per call.
>
> I was looking at maybe a system trigger don't see how it could be done
> so far.
>
> Any ideas?
>
>
>
>

Oracle provides the dbms_profiler package for this purpose. The book of Thomas Kyte contains a discussion on how to use it, and of course it is discussed in the Oracle manuals.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address