시간 오래 걸리는 쿼리는? ------------------------------------------------ -- sys 계정으로 들어가서 느린 쿼리를 골라 낸다. ------------------------------------------------ select sql_text, elapsed_time, executions, -- ((elapsed_time / executions ) || '(ms)') as AVG_ELA_TIME, last_load_time ((ROUND(ELAPSED_TIME/EXECUTIONS/1000000,4)) ||…

오라클 Full Scan 쿼리를 찾아보자. SELECT /*+ ORDERED USE_NL(A SQ)*/ SQL_FULLTEXT ,SQ.SQL_ID ,PLAN_HASH_VALUE ,SQ.MODULE ,TRUNC(CPU_TIME/DECODE(EXECUTIONS,0,1,EXECUTIONS)/1000/1000,2) AS CPU_ONE ,TRUNC(ELAPSED_TIME/DECODE(EXECUTIONS,0,1,EXECUTIONS)/1000/1000,2) AS EPLAP ,TRUNC(BUFFER_GETS/DECODE(EXECUTIONS,0,1,EXECUTIONS)/1000/1000,2) AS BUFFER_GET FROM (SELECT DISTINCT SQL_ID FROM V$SQL_PLAN WHERE…