Use sqlplus to track performance

Recently, there are a bunch of Delete statements to be executed. The 34 Delete statements are written as one PROCEDURE for execution, but the execution plan and time of a single DELETE statement cannot be seen during execution.

Recently, there are a bunch of Delete statements to be executed. The 34 Delete statements are written as one PROCEDURE for execution, but the execution plan and time of a single DELETE statement cannot be seen during execution.

There are a bunch of Delete statements to be executed recently. The 34 Delete statements are written as one PROCEDURE for execution, but the execution plan and time of a single DELETE statement cannot be seen during execution, think of using SQLPLUS to trace the execution time and plan of each DELETE:

In this way, you can see the detailed execution of each statement in track. log.