SQL Tracing for Application Workloads

Use SQL tracing to identify the source of excessive database workloads, such as high-load SQL statements in your application. You can trace the current session with ALTER SESSION, or use the DBMS_USERDIAG package to target a specific SQL statement, session, client identifier, or service, module, and action. You can also collect bind variable, wait event, and execution plan information for more detailed diagnostics.

See Perform SQL Tracing on Autonomous AI Database for more information.