Shulou(Shulou.com)06/01 Report--

Customer's production system is always so important, generally will not let you operate on their production machine for a long time, but analysis and generation of AWR reports are a relatively time-consuming work, of course, only one AWR report is not time-consuming, but to conduct a detailed analysis of the system, we may need all the AWR data over a period of time, which needs to be selected according to the actual situation. At this point, we need to export the customer's AWR data, and then analyze it. This operation mainly involves three stages: AWR data export, import and report generation. Each step is described in detail below.

1. Export

SQL > @? / rdbms/admin/awrextr.sql

~ ~ ~

~ ~ ~

Disclaimer: This SQL/Plus script should only be called under

The guidance of Oracle Support.

~ ~ ~

~ ~ ~

~

AWR EXTRACT

~

~

~ This script will extract the AWR data for a range of snapshots ~

~ into a dump file. The script will prompt users for the ~

~ following information: ~

~ (1) database id

~ (2) snapshot range to extract

~ 3 name of directory object ~

~ (4) name of dump file

~

Databases in this Workload Repository schema

~

DB Id DB Name Host

* 2182516689 GYL rac01

* 2182516689 GYL rac02

The default database id is the local one: '2182516689. To use this

Database id, press to continue, otherwise enter an alternative.

Enter value for dbid: 2182516689

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.