오라클 AWR 튜닝관련 테이블

  1. 튜닝 관련 SQL 
    select * from dba_hist_snapshot;
select * From dba_hist_sqlstat;
select * from dba_hist_sqltext;
  2. 실행계획 정보 PLAN_HASH_VALUE 
    select * from dba_hist_sql_plan;
  3. bind value 
    select * from dba_hist_sql_bind_metadata;
select * from dba_hist_sqlbind; -- VALUE_STRING
  4. SYSTEM 정보 
    select * from SYS.DBA_HIST_SYSSTAT ;