dbms:oracle:admin:tuning:table

오라클 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 ;
```

dbms/oracle/admin/tuning/table.txt · 마지막으로 수정됨: 2016/10/02 18:20 저자 starlits