12C 下的SQL Monitor

参考文档

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/arpls/DBMS_SQL_MONITOR.html#GUID-13874A73-369E-42CD-9C43-A12F1B3BDEC6

conn hr/hr
var dbop_eid number;
exec :dbop_eid:=dbms_sql_monitor.begin_operation('ORA.HR.select',forced_tracking=>'Y')

select a.employee_id,b.employee_id from hr.employees a,hr.employees b;
select * from hr.departments;
select a.table_name,b.table_name from dict a,dict b;

exec dbms_sql_monitor.end_operation('ORA.HR.select',:dbop_eid);

@>conn hr/hr@pdb1
Connected.
HR@pdb1>var dbop_eid number;
HR@pdb1>exec :dbop_eid:=dbms_sql_monitor.begin_operation('ORA.HR.select',forced_tracking=>'Y');

PL/SQL procedure successfully completed.

HR@pdb1>exec dbms_sql_monitor.end_operation('ORA.HR.select',:dbop_eid);

PL/SQL procedure successfully completed.

HR@pdb1>

在EM express下查看 性能- 性能中心 - Monitored SQL 

END 。