<div>
use statspack. documentation : ORACLE_HOME/rdbms/admin/sp<wbr />doc.txt
</div>


use statspack. documentation : ORACLE_HOME/rdbms/admin/spdoc.txt

<div>
Thank you very much for all.
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Our systems are running well-known ERP and Oracle 8i or above.<br />
We have performance issues.<br />
We can find problematic SQL statements (SQL full text)by monitoring, but we don't know<br />
which procedure/package the SQL statements were executed from.<br />
<br />
Could anyone please tell us how to find procedure/packages by SQL text?<br />
<br />
Assumption: we did not set module, action, client_info, etc by using<br />
DBMS_MONITOR and DBMS_APPLICATION_INFO packages.<br />
<br />
Thank you in advance.<br />

</div>
</div>


Hi,

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.


How to find procedure/package by SQL statement(SQL_TEXT) for tuning

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.