How do I profile stored procedures on Oracle?

Question

There is an Oracle DB to which I have access. I can view its packages using Aqua Data Studio and make queries to it. I don't have any access to the filesystem of the server.

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

I want to know which stored procedures and with what parameters are used by this binary. It seems to be impossible to do with "Statement monitor for Oracle" - it only logs direct query calls, not stored procedures.

Can it be done with built-in trace if I don't have access to the filesystem?

Is there some other tool?

Answer 1

You can use the DBMS_PROFILER package: http://download.oracle.com/docs/cd/B10501%5F01/appdev.920/a96624/12%5Ftune.htm#45936

Answer 2

You can try PLSQL/Developer,it support to debug your procedure step by step.