SQL> ALTER SESSION SET 'MONITOR_SQL_EXEC' = 1;
DMSQL 过程已成功完成
已用时间: 1.240(毫秒). 执行号:500.
SQL> select count(1) from t1 where owner='T1';

行号 COUNT(1)

1 0

已用时间: 00:00:43.819. 执行号:501.
SQL> select DBMS_SQLTUNE.REPORT_SQL_MONITOR(SQL_EXEC_ID=>501) from dual;
警告: 字符串截断

行号 DBMS_SQLTUNE.REPORT_SQL_MONITOR(SQL_EXEC_ID=>501)

1 SQL Monitoring Report

SQL Text

select count(1) from t1 where owner='T1';

Global Information

Status : DONE (ALL ROWS)
Session : SYSDBA (139980030678248:10)
SQL ID : 19
SQL Execution ID : 501
Execution Started : 2024-07-04 15:01:39
Duration : 43.818798s
Program : disql

Global Stats

| Affected | Bytes | Bytes | Physical | Logical |
| Rows | Allocate | Free | Read(page) | Read(page) |

|

已用时间: 4.406(毫秒). 执行号:502.
SQL>