Oracle 1Z0-076 Exam - Topic 4 Question 42 Discussion

Actual exam question for Oracle's 1Z0-076 exam

Question #: 42
Topic #: 4

Active Data Guard (ADG) databases are widely used to offload reporting or ad hoc query-only jobs from the primary database. Reporting workload profile is different from the primary database and often requires tuning.

Which tool is used to tune SQL workloads running on an ADG database?

AStandby Statspack

BIn-Memory Active Session History (ASH)

CAutomatic Diagnostic Database Monitor (ADDM)

DAutomatic Workload Repository (AWR)

ESQL Tuning Advisor

Show Suggested Answer

Suggested Answer: D

AWR collects, processes, and maintains performance statistics for problem detection and self-tuning purposes. In an Active Data Guard environment, where the physical standby database can be used for read-only workloads, AWR can be instrumental in identifying performance bottlenecks and areas for optimization. It provides detailed reports that include wait events, time model statistics, and active session history, making it an invaluable tool for tuning SQL queries and overall database performance in an ADG setup.

by Tamar at Jan 05, 2026, 05:16 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-076 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Thersa

3 days ago

D) AWR is the tool you want to use, unless you're feeling adventurous and want to try the "turn it off and on again" method.

upvoted 0 times

...

Chaya

8 days ago

Tuning an ADG database? Piece of cake! Just throw some fairy dust at it and it'll be good as new.

upvoted 0 times

...

Cristal

30 days ago

B) In-Memory Active Session History (ASH) is the tool I would use to tune the reporting workload on the ADG database.

upvoted 0 times

...

Lettie

1 month ago

E) SQL Tuning Advisor is the way to go for tuning SQL workloads on an ADG database.

upvoted 0 times

...

Naomi

1 month ago

D) Automatic Workload Repository (AWR) is the correct tool to tune SQL workloads running on an ADG database.

upvoted 0 times

...

Pa

2 months ago

I’m leaning towards Standby Statspack, but I’m not confident if it’s the best tool for tuning in an ADG context.

upvoted 0 times

...

Brittney

2 months ago

I feel like the Automatic Diagnostic Database Monitor could be useful here, but it seems more general than what we need for tuning SQL workloads.

upvoted 0 times

...

Noelia

2 months ago

I remember we discussed AWR reports in class, but I can't recall if they specifically apply to ADG databases.

upvoted 0 times

...

Susy

2 months ago

I think the SQL Tuning Advisor might be the right choice since it focuses on optimizing SQL queries, but I'm not entirely sure.

upvoted 0 times

...

Douglass

2 months ago

Hmm, I'm a bit stuck on this one. The question is specifically about tuning SQL workloads on the ADG, so I'm not sure the general database monitoring tools like ADDM or AWR are the right answer. Maybe it's something more specialized like the In-Memory ASH option?

upvoted 0 times

...

Leeann

2 months ago

I'm pretty confident the answer is D) Automatic Workload Repository (AWR). That's the standard tool we use for performance analysis and tuning across the entire database environment, including standby systems like ADG.

upvoted 0 times

...

Sina

3 months ago

Okay, let me think this through. The question is asking about tuning the reporting workload on the ADG, which is different from the primary. So I'm guessing the right answer is probably not the general tools like ADDM or SQL Tuning Advisor. I'm leaning towards D) AWR, but I'll double-check the other options just to be sure.

upvoted 0 times

...

Nelida

3 months ago

Hmm, I'm not sure about this one. The question is specifically about tuning SQL workloads on the ADG, so I'm wondering if the answer might be something more specialized like B) In-Memory Active Session History (ASH).

upvoted 0 times

...

Lauryn

3 months ago

I think the answer is D) Automatic Workload Repository (AWR). That's the tool we use to analyze performance on the primary database, so it makes sense it would also be used for the ADG.

upvoted 0 times

...