문서의 이전 판입니다!

Automatic Management

Objectives

데이타베이스 성능 진단을 위한 다양한 툴을 이야기 할 수 있다.
데이타베이스 Advisors를 활용할 수 있다.
SQL Tuning Advisor를 이용하여 데이타베이스 성능을 향상 시킬 수 있다.

Oracle Wait Events

wait과 wait이 발생하는 이유를 통하여 세션과 프로세스 정보를 제공하여 Wait Events를 수집한다.
다양한 이벤트는 V$EVENT_NAME 뷰를 통하여 조회할 수 있다.

System Statistics

예

Displaying Systemwide Statistics 1

 SELECT name, class, VALUE FROM v$sysstat;

Displaying Systemwide Statistics 2

 SELECT * FROM V$SYSTEM_WAIT_CLASS WHERE wait_class LIKE '%I/O%';

SGA Global Statistics
```
 SELECT * FROM v$sgastat; 
```

Displaying Session-Related Statistics

Troubleshooting and Tuning Views

Statistics Collection

통계정보 종류

Optimizer statistics
System statistics

통계수집 방법

– Automatically through GATHER_STATS_JOB
– Manually with the DBMS_STATS package
– By setting database initialization parameters
– Importing statistics from another database

adminschool.net wiki

목차

Automatic Management

Objectives

Oracle Wait Events

System Statistics

예

Displaying Session-Related Statistics

Troubleshooting and Tuning Views

Statistics Collection

통계정보 종류

통계수집 방법

Automatic Optimizer Statistics Collection: Overview

Dictionary and Special Views

Statspack

Workload Repository

AWR Snapshot Baselines

Advisory Framework Overview

Database Control and Advisors

Typical Advisor Tuning Session

Manually Invoking ADDM

Application Tuning Challenges

SQL Tuning Advisor Overview

SQL Tuning Advisor Options and Recommendations

Using the SQL Tuning Advisor

Using the SQL Tuning Advisor: Example

Using the SQL Access Advisor

The Undo Management Page

Automatic Undo Retention Tuning

The Undo Advisor Page

Summary

Practice Overview: Optimizing Database Performance

adminschool.net wiki

사용자 도구

사이트 도구

목차

Automatic Management

Objectives

Oracle Wait Events

System Statistics

예

Displaying Session-Related Statistics

Troubleshooting and Tuning Views

Statistics Collection

통계정보 종류

통계수집 방법

Automatic Optimizer Statistics Collection: Overview

Dictionary and Special Views

Statspack

Workload Repository

AWR Snapshot Baselines

Advisory Framework Overview

Database Control and Advisors

Typical Advisor Tuning Session

Manually Invoking ADDM

Application Tuning Challenges

SQL Tuning Advisor Overview

SQL Tuning Advisor Options and Recommendations

Using the SQL Tuning Advisor

Using the SQL Tuning Advisor: Example

Using the SQL Access Advisor

The Undo Management Page

Automatic Undo Retention Tuning

The Undo Advisor Page

Summary

Practice Overview: Optimizing Database Performance

문서 도구