三种方式:alter session set statistics_level = all;select * from test1 where object_name = 'TEST1'; --执行要查看计划的语句select * from table(dbms_xplan.display_cursor(null,null,'ADVANCED ALLSTATS LAST PEEKED_BINDS'));alter session set statistics_level...
显示全部三种方式:
alter session set statistics_level = all;
select * from test1 where object_name = 'TEST1'; --执行要查看计划的语句
select * from table(dbms_xplan.display_cursor(null,null,'ADVANCED ALLSTATS LAST PEEKED_BINDS'));
alter session set statistics_level = typical;
或者
set line 400
set pagesize 0
select /*+ gather_plan_statistics*/ * from test1 where object_name ='TEST1';
select * from table(dbms_xplan.display_cursor(null,null,'ADVANCED ALLSTATS LAST PEEKED_BINDS'));
或者
select * from table(dbms_xplan.display_cursor('0vvq1r06ury94',null,'ADVANCED ALLSTATS LAST PEEKED_BINDS'));
收起