v$sql_monitor

查看视图

desc v$sql_monitor
select * from v$sql_monitor;

V$SQL_MONITOR

实验模拟

select /*+ parallel(8) */count(1) from dba_objects;

col status format a20
col username format a30
col program format a30
col sql_id format a20
col sql_text format a50
select status, username, program, sql_id, sql_text from v$sql_monitor;

set linesize 200
col comm format a200
SELECT dbms_sqltune.report_sql_monitor(
sql_id => '2hxhny9phgu37',
report_level => 'ALL',
type=>'TEXT'
) comm 
FROM dual;

视图

https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-SQL_MONITOR.html#GUID-79E97A84-9C27-4A5E-AC0D-C12CB3E748E6

https://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_3052.htm#REFRN30479