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

Which two statements are true about the Automatic Workload Repository (AWR)? (Choose two.)

A. All AWR tables belong to the SYSTEM schema

B. The AWR contains system wide tracing and logging information

C. The snapshots collected by the AWR are accessible through data dictionary views

D. The snapshots collected by the AWR are used by self-tuning components in the databas

Which two sentences are true about the automatic load knowledge base (AWR)? (select two)

a. All AWR tables belong to SYSTEM users

B. AWR contains system tracking information, login information

C. snapshots collected by AWR can be accessed through a data dictionary

D. snapshots collected by AWR are used by the self-tuning component of the database

An error, AWR belongs to sysman and is stored in sysaux tablespace

B error, this is the function of ADR

If C is correct, dba_hist_snapshot can query it.

D correct, AWR is the basis of all self-management functions

Knowledge points: AWR:Automatic Workload Repository, automatic workload knowledge base

1. Exists for a set of tables and other objects in the SYSAUX tablespace

two。 The level of statistics collection is controlled by the instance parameter STATISTICS_LEVEL, and there are three values:

BASIC: almost all statistics collection is disabled.

TYPICAL: the default level, which allows you to collect all the statistics needed for normal adjustments without collecting a collection of statistics that have an adverse impact on performance.

ALL: collects extremely detailed statistics related to the execution of SQL statements.

3. Statistics are accumulated in memory and are written to disk periodically (by default, once per hour) by the MMON process, that is, to AWR, which is called an AWR snapshot

4.AWR configurations are all configured through the dbms_workload_repository package

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.