Which four are true about performance-related Oracle tools?

The correct answer is A. The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two B. SQL Performance Analyzer can suggest schema changes. C. SQL Performance Analyzer can identify regressed SQL statements. F. The Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two. Options A and F are correct because the ADDM Compare Period report supports comparing two different time periods on the same database (A) AND two different databases (F) - both are valid use cases for identifying performance regressions between workloads. B is correct because…

Monitoring and Tuning

Question

Options

AThe Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two
BSQL Performance Analyzer can suggest schema changes.
CSQL Performance Analyzer can identify regressed SQL statements.
DDatabase Replay always uses one replay client for all the original database sessions.
EDatabase Replay always uses one replay client for each original database session.
FThe Automatic Database Diagnostic Monitor (ADDM) Compare Period report can compare two
GThe Active Session History (ASH) report is based on wait event samples.

How the community answered

(50 responses)

A
76% (38)
D
4% (2)
E
6% (3)
G
14% (7)

Explanation

Options A and F are correct because the ADDM Compare Period report supports comparing two different time periods on the same database (A) AND two different databases (F) - both are valid use cases for identifying performance regressions between workloads. B is correct because SQL Performance Analyzer (SPA) can recommend schema changes such as creating indexes or SQL profiles to improve execution plans. C is correct because identifying regressed SQL statements - queries that perform worse after a change - is SPA's primary purpose.

D and E are both wrong because neither absolute is true: Database Replay supports multiple replay clients and scales them based on workload, so neither "always one client for all sessions" nor "always one client per session" is accurate. G is wrong because ASH is based on active session samples (taken every second), which capture the full session state including SQL, objects, and wait events - calling it purely "wait event samples" is misleading and incomplete.

Memory tip: Think of the tools by their purpose - SPA analyzes SQL (finds regressions, suggests fixes), ADDM compares periods/databases, Database Replay replays workloads with flexible client scaling, and ASH samples active sessions (not just waits). The distractors for Database Replay (D/E) both use the word "always," which is a red flag for absolute statements in exam questions.

Topics

#ADDM#SQL Performance Analyzer#Database Replay#Active Session History

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice