Get the latest version compatible with your database (e.g., 12c, 19c).

Use this to execute a specific SQL script and collect real-time execution statistics.

You will be prompted to provide a password for the SQLTXPLAIN user and select default/temporary tablespaces for storing diagnostic data. 2. Executing a Diagnostic Run

Use this if you know the SQL_ID of the problematic statement. @sqltxtract.sql Use code with caution. Copied to clipboard

Connect as SYSDBA and execute the creation script: @sqcreate.sql Use code with caution. Copied to clipboard