Exam 1z0-062 topic 1 question 274 discussion

Actual exam question from Oracle's 1z0-062

Question #: 274
Topic #: 1

[All 1z0-062 Questions]

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

A. An AWR snapshot shows the SQL statements that are producing the highest load on the system, based on criteria such as elapsed time and CPU time.
B. AWR data is stored in memory and in a database.
C. All AWR tables belong to the SYSTEM schema.
D. The manageability monitor (MMON) process gathers statistics and creates an AWR snapshot that is used by the self-tuning components in a database.
E. An AWR snapshot contains system-wide tracing and logging information.

Show Suggested Answer

Suggested Answer: ABD 🗳️

by khan at April 21, 2019, 9:21 p.m.

Comments

Submit Cancel

khan

Highly Voted 6 years, 1 month ago

The largest portion of the SYSAUX tablespace is occupied by the Automatic Workload Repository (AWR) https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces010.htm#ADMIN11387

upvoted 5 times

Monaguetta

3 years, 9 months ago

Thus the answer should be A,D,E as: * AWR tables belong to SYS users and are stored in SYSAUX tablespace * AWR does not use any space in the SGA --> it's not stored in memory

upvoted 2 times

SYSAUX is not the default SYSTEM schema tablespace, it's SYSTEM. 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. https://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF02601

upvoted 1 times

...

Ray520

Most Recent 2 years, 10 months ago

A is not completely correct as AWR not just has SQL commands, it's only a section of the report. It has entire system level stats, including OS stats.

upvoted 1 times

...

Ray520

2 years, 10 months ago

C. All AWR tables belong to the SYSTEM schema. I am unsure of this. SYSAUX is a auxiallry TS created for SYSTEM schema but all objects on SYSAUX need not be owned by SYSTEM as SYSAUX can be alloted to any other schema. SYSTEM schema owns the SYSTEM TS. Since AWR data lies in SYSAUX TS, I'm confused if C is correct.

upvoted 1 times

...

Ray520

2 years, 10 months ago

Selected Answer: BCD

https://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF02601

upvoted 1 times

...