利用者:CamillaRuth908

出典: くみこみックス

---

最新版

In Oracle Database 10g Oracle replaced statspack while using Advanced Workload Repository (AWR). The job of AWR is always to collect database figures (by default every hour) and this data is maintained for any week and after that purged. You can then run reports towards these statistics to performance tune your own database. Other Oracle features for instance ADDM and the particular database advisors utilize database statistics to monitor and examine the database seeking performance problems. If you create an awr report data bank, AWR is automatically installed and empowered. Statistics collection is usually automated, and the data collected by AWR are stored within the database. In purchase to properly acquire database statistics, the parameter STATISTICS_LEVEL ought to be set to USUAL (the default) or perhaps ALL. If STATISTICS_LEVEL is set to BASIC then this AWR will always be disabled. Oracle 11g can retains eight days of AWR bio information (as against seven in Oracle 10g). As always you can override the default. This value will simply be set with newly created directories. Databases that are upgraded can keep the AWR storage value already set for them.

The Oracle repository uses get more information pertaining to problem detection and analysis along with for self-tuning. A variety of statistics are collected through the AWR including hang on events, time product statistics, active treatment history statistics, different system and treatment level statistics, object usage statistics and information on the most resource intensive SQL assertions. Other Oracle Database 10g features use the AWR, including ADDM and also the other advisors throughout Oracle Database 10g.

If you want to explore the AWR database, feel free to accomplish this. The AWR consists of a number of tables owned from the SYS schema in addition to typically stored inside the link here (currently no method exists to go these objects to another tablespace). All AWR table names focus on the identifier WR. Following WR is really a mnemonic that identifies the kind designation of the table followed by a dollar indication. AWR tables have three different sort designations: Metadata (WRM)

AWR tables associated with advisor functions (WRI) The majority of the AWR table labels are pretty self explanatory such as WRM_SNAPSHOT or WRH_ACTIVE_SESSION_HISTORY. In some Oracle technical documents you will note the AWR dining tables also refereed to as the select workload databases (SWRF) tables. Oracle Database 10g also provides several DBA tables that assist you to query the AWR repository. The tables all start with DBA_HIST, followed by way of name that details the table. For instance , tables such while DBA_HIST_FILESTATS, DBA_HIST_DATAFILE or perhaps DBA_HIST_SNAPSHOT.