Which three statements are true about Automatic Workload Repository (AWR)?
A.
All AWR tables belong to the SYSTEM schema.
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 v$SYS time model and V$SESS_TIME_MODEL views.
E.
AWR contains system wide tracing and logging information.
Explanation:
* A fundamental aspect of the workload repository is that it collects and persists
database performance data in a manner that enables historical performance analysis.
The mechanism for this is the AWR snapshot. On a periodic basis, AWR takes a
“snapshot” of the current statistic values stored in the database instance’s memory
and persists them to its tables residing in the SYSAUX tablespace.
* AWR is primarily designed to provide input to higherlevel components such as automatic tuning
algorithms and advisors, but can also provide a wealth of information for the manual tuning
process.
CDE
Agree CDE is correct answer
“Automatic Workload Repository (AWR) collects, processes, and maintains performance statistics for problem detection and self-tuning purposes. This data is both in memory and stored in the database.”
“Time model statistics based on time usage for activities, displayed in the V$SYS_TIME_MODEL and V$SESS_TIME_MODEL views”
http://docs.oracle.com/cd/B28359_01/server.111/b28274/autostat.htm#PFGRF02601
So, looks like BCD
CDE as AWR data is not stored in memory and belong to sys schema
It is from the referred doc and in above comments.
“This data is both in memory and stored in the database”
So more appropriate is BCD. E does not look relevant here but also looks ok.
BCD.
Not E.
The automatic diagnostic repository (ADR) is a systemwide tracing and logging central repository
http://docs.oracle.com/cd/E11882_01/network.112/e10836/trouble.htm#NETAG016
Considering the Oracle docuentation quoted by Eder (data located in memory and database) and Domingo (about ADR), I would say BCD too. AWR is owned by SYS and there are no tracing in the AWR data.
AWR includes the ASH also so B is correct.
BCD
B,C,D
I think B,C,D and not E because AWR doesn’t do tracing and logging.
BCD is final answer!
BCD
BCD
The Automatic Workload Repository (AWR) collects, processes, and maintains performance statistics for problem detection and self-tuning purposes. This data is both in memory and stored in the database. The gathered data can be displayed in both reports and views.
The statistics collected and processed by AWR include:
Object statistics that determine both access and usage statistics of database segments
Time model statistics based on time usage for activities, displayed in the V$SYS_TIME_MODEL and V$SESS_TIME_MODEL views.
Hence the answers are: B, C, D
B ,C and D only
(
The Automatic Workload Repository (AWR) collects, processes, and maintains performance statistics for problem detection and self-tuning purposes. This data is both in memory and stored in the database. The gathered data can be displayed in both reports and views.
The statistics collected and processed by AWR include:
Object statistics that determine both access and usage statistics of database segments
Time model statistics based on time usage for activities, displayed in the V$SYS_TIME_MODEL and V$SESS_TIME_MODEL views
Some of the system and session statistics collected in the V$SYSSTAT and V$SESSTAT views
SQL statements that are producing the highest load on the system, based on criteria such as elapsed time and CPU time
Active Session History (ASH) statistics, representing the history of recent sessions activity
)
Answer is BCD
https://docs.oracle.com/database/121/TGDBA/gather_stats.htm#TGDBA169
6.1.1 Automatic Workload Repository
AWR collects, processes, and maintains performance statistics for problem detection and self-tuning purposes. This gathered data is stored both in memory and in the database, and is displayed in both reports and views.
The statistics collected and processed by AWR include:
Object statistics that determine both access and usage statistics of database segments
Time model statistics based on time usage for activities, displayed in the V$SYS_TIME_MODEL and V$SESS_TIME_MODEL views
Some of the system and session statistics collected in the V$SYSSTAT and V$SESSTAT views
SQL statements that are producing the highest load on the system, based on criteria such as elapsed time and CPU time
Active Session History (ASH) statistics, representing the history of recent sessions activity
BCD
AWR store in memory and flush every interval (default 1h) to db.
so BCD.
BCD no doubts