7. Reactive Tuning 2010/01/16
Ploblem - OS - Application - Instance OS Issues - Memory - CPU - I/O (Disk and Network) cf. OS Statistics : V$OSSTAT 에서 일부 확인가..
6. Using Automatic Workload Repository 2010/01/15
AWR (Automatic Workload Repository) - SYS 소유 - SYSAUX TS 에 존재 - MMON에 의해 자동으로 60분마다 수집 / 7일간 유지 (Default) - MMON 에 의해 자동으로 삭제..
Statspack 생성/삭제/Sanpshot생성 2010/01/15
Statspack 생성 SQL> shutdown abort SQL> startup SQL> !ls $ORACLE_HOME/rdbms/admin/sp* ... /u01/app/oracle/product/10.2.0/db_1/rd..
4. Metrics, Alert, and Baselines 2010/01/15
Metric - Base Statistics 로부터 2차가공된 Statistics - MMON 에 의해 자동으로 가공 In-Memory ▒ V$SYSMETRIC_HISTORY ▒ V$FILEMETRIC_HISTORY ▒ V$W..
Read the alert log with SQL
2010/01/13
ASM Instance 구성 + EM 등록
2010/01/02
EM(Enterprise Manager) Port 번호 변경
2009/12/29
ORA - 04031 PX 관련
2009/12/28
Clone Database
2009/12/22
User Managed B&R
2009/12/18
iSQLPlus Session 접속시간 변경
2009/12/17
장애유형 별 복구 (완전복구)
2009/12/11
Archive 실습
2009/12/11
Lock 관련
2009/12/03
17. Flashback
2009/12/15
15. Backup
2009/12/14
14. Backup and Recovery Concepts
2009/12/10
13. Performance Management
2009/12/09
12. Monitoring & Tuning
2009/12/07
11. Network
2009/12/04
10. Security
2009/12/04
9. Managing Undo Data
2009/12/03
8. Lock
2009/12/02
7. Object Management
2009/11/30
13. Resource Manager
2010/01/07
12. Automatic Storage Management
2010/01/07
11. Managing Storage
2010/01/06
10. Managing Schema Objects
2009/12/30
9. Automatic Performance Management
2009/12/29
8. Memory
2009/12/24
7. Block Corruption
2009/12/23
6. Flashback
2009/12/23
5. Database Recovery
2009/12/22
4. Recovering from Noncritical Losses
2009/12/21
7. Reactive Tuning
2010/01/16
6. Using Automatic Workload Repository
2010/01/15
4. Metrics, Alert, and Baselines
2010/01/15
3. Statistics and Wait Events
2010/01/13
2. Performance Tuning : Overview
2010/01/12
1. Introduction
2010/01/12
