How to find procedure/package by SQL statement(SQL_TEXT) for tuning
Posted on 2004-10-21
Our systems are running well-known ERP and Oracle 8i or above.
We have performance issues.
We can find problematic SQL statements (SQL full text)by monitoring, but we don't know
which procedure/package the SQL statements were executed from.
Could anyone please tell us how to find procedure/packages by SQL text?
Assumption: we did not set module, action, client_info, etc by using
DBMS_MONITOR and DBMS_APPLICATION_INFO packages.
Thank you in advance.