sqlplus iseadmin/iseadmin
①解析結果を削除
delete from plan_table where statement_id='TEST_PLAN';
②取得
explain plan set statement_id = 'TEST_PLAN' for
SELECT
h.docno,h.hid,h.upload_date,h.filename,h.ext,m.mid,m.name,m.type,m.primary_gname,m.alpha,m.primary_galpha
FROM is_lib_history_0 h,is_member m
WHERE h.mid=m.mid(+) AND h.docno=&1
ORDER BY h.upload_date desc;
③確認
select id||','||operation||','||substr(options, 1, 15)||','||
object_name||','||cost||','||parent_id||','||position
from plan_table where statement_id='TEST_PLAN' order by id;
