oracle02

http://www.doppo1.net/oracle/tuning/explain-plan.html


sqlplus noboru01/noboru01
select * from tbl01 where id1 < '00001322';

column sql_text format a50
SELECT ADDRESS,HASH_VALUE,SQL_TEXT FROM V$SQL WHERE SQL_TEXT LIKE 'select% from tbl%';

column operation format a30
column object_name format a20
SELECT A.ID, LPAD(' ',2*(DEPTH-1)) || A.OPERATION || nvl2(OPTIMIZER,'(' || OPTIMIZER || ')',NULL) || nvl2(A.OPTIONS,' ' ||
A.OPTIONS ,NULL) OPERATION, A.OBJECT_NAME,A.BYTES,A.COST,A.CPU_COST,A.IO_COST,A.CARDINALITY FROM V$SQL_PLAN A
WHERE A.ADDRESS='25ECB24C' AND A.HASH_VALUE='2518582849' AND A.CHILD_NUMBER=0  ORDER BY ID;