ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam
Go to Exam

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 Hide Answer
Suggested Answer: ABD 🗳️
by khan at April 21, 2019, 9:21 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
khan
Highly Voted 5 years, 7 months 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, 3 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
Ray520
2 years, 4 months ago
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, 4 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, 4 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, 4 months ago
Selected Answer: BCD
https://docs.oracle.com/cd/E11882_01/server.112/e41573/autostat.htm#PFGRF02601
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago