{パフォーマンスの管理その他}DBMS_MONITORでSQLトレースを取得

 

https://docs.oracle.com/cd/F19136_01/tgsql/performing-application-tracing.html#GUID-F872D6F9-E015-481F-80F6-8A7036A6AD29

conn sh/sh

SELECT SID, SERIAL#, USERNAME 
FROM   V$SESSION
WHERE  USERNAME = 'SH';

 

ALTER SESSION SET TRACEFILE_IDENTIFIER = 'my_monit';

EXECUTE DBMS_MONITOR.SESSION_TRACE_ENABLE(157,54586, TRUE, FALSE);
select max(prod_id) from sh.sales;
EXECUTE DBMS_MONITOR.SESSION_TRACE_DISABLE(157,54586);

 

tkprof orcl_ora_11586_my_monit.trc orcl_ora_11586_my_monit.txt sys=no 
cat orcl_ora_11586_my_monit.txt