문서의 이전 판입니다!

오라클 AWR 튜닝관련 테이블

– 튜닝 관련 SQL select * from dba_hist_snapshot; select * From dba_hist_sqlstat; select * from dba_hist_sqltext;

– 실행계획 정보 PLAN_HASH_VALUE select * from dba_hist_sql_plan;

– bind value select * from dba_hist_sql_bind_metadata; select * from dba_hist_sqlbind; – VALUE_STRING

– SYSTEM 정보 select * from SYS.DBA_HIST_SYSSTAT ;