Friday 15 June 2012

How do I profile stored procedures on Oracle? -


There is an Oracle DB on which I have access. I can view my package using Aqua Data Studio and ask questions for it. I do not have access to the server's file system.

There is also a binary that uses that database by calling stored procedures from it.

I want to know which types of stored procedures and which parameters are used by this binary to do this, it is impossible to do this with "Oracle's Statement Monitor" - this is just a direct query call Logs in, not stored procedures.

If I do not have access, can it be done with an underlying trace?

You can use the DBMS_ PROFILER package:


No comments:

Post a Comment