(1)
declare type array_table is table of varchar2(4000 char) index by binary_integer; --定义表 lvc_array array_table; i number; begin dbms_output.enable(buffer_size => null); --防止默认2000个字节的报错 execute immediate 'select * from TABLE(DBMS_XPLAN.DISPLAY_CURSOR(''b48q9r2cmh4j6'', 0, ''ADVANCED''))' bulk collect into lvc_array; --利用select * bulk collect into for i in 1 .. lvc_array.count loop --利用for in loop end loop遍历列表元素 dbms_output.put_line(lvc_array(i)); end loop; end;
(2)另外一种查看执行计划的方法：
select * from TABLE(DBMS_XPLAN.DISPLAY_CURSOR('b48q9r2cmh4j6', 0, 'ADVANCED'));
(3)查看锁对象，sql_id
SELECT object_name, machine, s.username, s.sid, s.serial#, s.blocking_session, s.wait_class, s.seconds_in_wait, s.inst_id, s.sql_id, s.paddr FROM gv$locked_object l, dba_objects o, gv$session s WHERE l.object_id = o.object_id AND l.session_id = s.sid and s.username in (‘’);
(4)根据sql_id查看完整的sql语句
select sql_fulltext from gv$sqlarea where sql_id='9adg331b11gry'
