sql 최적화를 위해 sql 표현식등을 보고 database단에 최적화 수행
아래 쿼리는 directive 상황을 확인하는 쿼리
SET LINESIZE 200
COLUMN dir_id FORMAT A20
COLUMN owner FORMAT A10
COLUMN object_name FORMAT A10
COLUMN col_name FORMAT A10
SELECT TO_CHAR(d.directive_id) dir_id, o.owner, o.object_name, o.subobject_name col_name, o.object_type, d.type, d.state, d.reason FROM dba_sql_plan_directives d, dba_sql_plan_dir_objects o WHERE d.directive_id=o.directive_id AND o.owner = 'TEST' ORDER BY 1,2,3,4,5;