뽁

[튜닝] 오라클 xplan 활용

ALTER SESSION SET statistics_level = ALL; /******************************************************************************** display_cursor(SQL_ID, child number,'ALLSTATS LAST +predicate') ********************************************************************************/ -- SQL_ID dgvrp584qjn2m, child number 1 SELECT * FROM table(dbms_xplan.display_cursor(null,null,'ALLSTATS LAST +predicate')) ; -..
IT Cafe+/ORACLE DB 2014. 11. 6. 15:41
Prev 1 ··· 17 18 19 20 Next