dbaplus Community

Nov 27, 2016 · Databases

How to Trace Recursive SQL Calls in Oracle Using 10046 and Orasrp

This article demonstrates step‑by‑step how Oracle DBAs can identify the origin of recursive SQL statements by leveraging the 10046 trace at both SQL‑ID and session levels, analyzing the trace with the Orasrp tool, and ultimately pinpointing the PL/SQL function that generated the query.