dbms:oracle:admin:tuning:table
차이
문서의 선택한 두 판 사이의 차이를 보여줍니다.
| 다음 판 | 이전 판 | ||
| dbms:oracle:admin:tuning:table [2016/10/02 18:17] – 만듦 starlits | dbms:oracle:admin:tuning:table [2016/10/02 18:20] (현재) – 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 ; | ||
| + | </ | ||
dbms/oracle/admin/tuning/table.1475401658.txt.gz · 마지막으로 수정됨: 저자 starlits
