[ORACLE] AWR 이용한 SQL PLAN 변경 확인
sql_id와 awr를 이용한 sql plan 변경 확인 쿼리 /* sql_stat from awr(sql_id) */ select /*+ parallel(16) */ b.BEGIN_INTERVAL_TIME, b.END_INTERVAL_TIME , to_char(b.END_INTERVAL_TIME,'yyyymmdd') day , to_char(b.END_INTERVAL_TIME,'hh24') hour , to_char(b.END_INTERVAL_TIME,'mi') min ,a.SNAP_ID ,a.INSTANCE_NUMBER ,a.SQL_ID ,a.PLAN_HASH_VALUE ,a.PARSING_SCHEMA_NAME ,a.EXECUTIONS_DELTA ,TRIM( REP..
2024. 5. 29.