sqlplus test/test@pdb11
-- 単純データベース操作
SELECT /*+ MONITOR */ /* HOGE */ SYSDATE FROM DUAL;
SELECT /*+ MONITOR */ /* HOGE */ count(*) from dba_objects;
SELECT * FROM V$SQL_MONITOR
WHERE SQL_TEXT like '%HOGE%'
;
-- 複合データベース操作
VAR eid NUMBER
EXEC :eid := DBMS_SQL_MONITOR.BEGIN_OPERATION('test')
begin
while true loop
update /* FUGA */ tab1 set col1=col1;
end loop;
end;
/
EXEC DBMS_SQL_MONITOR.END_OPERATION('test', :eid);
SELECT * FROM V$SQL_MONITOR
WHERE SQL_TEXT like '%FUGA%'
;
set long 40000
set longchunksize 40000
select DBMS_SQL_MONITOR.REPORT_SQL_MONITOR from dual;
