BLE
set feedback off
set verify off
set pages 2000
column operation format a40
column object format a10
TTITLE * STATEMENT_ID = '&1' *
select object_name object,
lpad(' ',level-1)||operation||'('||options||')' operation
from plan_table
start with id = 0 and statement_id = '&1'
connect by prior id = parent_id and statement_id = '&1';
REM -- exists.sql - examples with EXPLAIN PLAN
REM -- IN vs. EXISTS
REM -- if you don't have a PLAN_TABLE, run ...
REM -- @?/rdbms/admin/xplan
alter session se页码：[1] [2] [3] [4] [5] [6] [7] [8] 第5页、共8页 |
