[2026] Oracle Database 19c Performance and Tuning Management

문제1

A Standard Edition production database has performance problems for two hours on the same day each week.
Which tool must you use to diagnose the problem?

A. AWR Compare Periods report

B. Statspack report

C. SQL Performance Analyzer

D. Database Replay

정답: B

설명: (Fast2test 회원만 볼 수 있음)

문제2

Accessing the SALES tables causes excessive db file sequential read wait events.
Examine this AWR except:

Now, examine these attributes displayed by querying dba_tables:

Finally, examine these parameter settings:

Which two must both be used to reduce these excessive waits?

A. Re-create the SALES table.

B. Compress the SALES table.

C. Partition the SALES table.

D. Coalesce all sales table indexes.

E. Increase PCTFREE for the SALES table.

정답: B,C

설명: (Fast2test 회원만 볼 수 있음)

문제3

Examine these commands, which execute successfully:

Which statement is true?

A. ADDM, AWR, and ASH reports can be purged automatically.

B. AWR snapshots can be purged manually in pluggable databases.

C. AWR- snapshots in all pluggable databases will be purged automatically after every 60 mins.

D. AD DM is enabled for all pluggable databases.

정답: B

설명: (Fast2test 회원만 볼 수 있음)

문제4

What is the right time to stop tuning an Oracle database?

A. When the allocated budget for performance tuning has been exhausted

B. When the tuning goal has been met

C. When the buffer cache and library cache hit ratio is above 95%

D. When all the concurrency waits are eliminated from the Top 10

E. When the I/O is less than 10% of the DB time

정답: B

설명: (Fast2test 회원만 볼 수 있음)

문제5

Examine this command:

What is the maximum number of baselines generated by this command that you can have at any given time?

A. 52

B. 3

C. 1

D. 5

정답: A

설명: (Fast2test 회원만 볼 수 있음)

문제6

SGA_TARGET and PGA_AGGREGATE_TARGET are configured to nonzero values.
MEMORY_target is then set to a nonzero value but memory_MAX_TARGET is not set.
Which two statements are true?

A.