Which three statements are true about Automatic Workload Repository (AWR)?

The correct answer is B. The AWR data is stored in memory and in the database. C. The snapshots collected by AWR are used by the self-tuning components in the database D. AWR computes time model statistics based on time usage for activities, which are displayed in. The statistics collected and processed by AWR include: Time model statistics based on time usage for activities, displayed in the V$SYS_TIME_MODEL and V$SESS_TIME_MODEL views

New Features for Performance

Question

Options

AAll AWR tables belong to the SYSTEM schema.
BThe AWR data is stored in memory and in the database.
CThe snapshots collected by AWR are used by the self-tuning components in the database
DAWR computes time model statistics based on time usage for activities, which are displayed in
EAWR contains systemwide tracing and logging information.

How the community answered

(37 responses)

A
8% (3)
B
86% (32)
E
5% (2)

Explanation

The statistics collected and processed by AWR include: Time model statistics based on time usage for activities, displayed in the V$SYS_TIME_MODEL and V$SESS_TIME_MODEL views

Topics

#AWR#snapshots#time model statistics#self-tuning components

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice