문서의 선택한 두 판 사이의 차이를 보여줍니다.
다음 판 | 이전 판 | ||
dbms:oracle:admin:tuning:table [2016/10/02 18:47] starlits 만듦 |
dbms:oracle:admin:tuning:table [2016/10/02 18:50] (현재) starlits |
||
---|---|---|---|
줄 1: | 줄 1: | ||
====== 오라클 AWR 튜닝관련 테이블 ====== | ====== 오라클 AWR 튜닝관련 테이블 ====== | ||
- | -- 튜닝 관련 SQL | + | |
select * from dba_hist_snapshot; | select * from dba_hist_snapshot; | ||
select * From dba_hist_sqlstat; | select * From dba_hist_sqlstat; | ||
select * from dba_hist_sqltext; | select * from dba_hist_sqltext; | ||
- | + | </ | |
- | -- 실행계획 정보 PLAN_HASH_VALUE | + | - 실행계획 정보 PLAN_HASH_VALUE |
select * from dba_hist_sql_plan; | select * from dba_hist_sql_plan; | ||
- | + | </ | |
- | -- bind value | + | - bind value < |
select * from dba_hist_sql_bind_metadata; | select * from dba_hist_sql_bind_metadata; | ||
select * from dba_hist_sqlbind; | select * from dba_hist_sqlbind; | ||
- | + | </ | |
- | -- SYSTEM 정보 | + | - SYSTEM 정보 |
select * from SYS.DBA_HIST_SYSSTAT ; | select * from SYS.DBA_HIST_SYSSTAT ; | ||
+ | </ |