How do I profile stored procedures on Oracle?

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 do开发者_如何学编程n't have access to the filesystem?

Is there some other tool?

You can use the DBMS_PROFILER package: http://download.oracle.com/docs/cd/B10501_01/appdev.920/a96624/12_tune.htm#45936

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