I am a newbie to Oracle. I have been assigned to find all used packages, functions and procedures used by the (client) system (legacy system). I have found a solution to that by using AUDIT. The problem is that the AUDIT does not allow us to trace/track package functions or procedures - that is I have a list of packages and function/procedures used by our client system now, but what I should do now is to find functions and procedures used (or not used by the client system) inside the list of those packages. In other words, how one can track or log function/procedure of a package invoked (used).
I reference DBMS_TRACE and DBMS_PROFILE to determine which function/procedure is invoked, but they do not give me information about package and its corresponding sub-program(s). The solution should give me information about sub-program unit called (used) by the clientside - that is it should not only give me package reference (since I have got packages used), but also give me the packages' sub-program run(called/invoked).
Or is there any way to fire a kind of trigger/event on a package/package subprogram called.
Could anyone help me please? Could be appreciated.