최신Oracle Database 19c Performance and Tuning Management - 1z1-084무료샘플문제

A. The buffer cache advisory view v$db_cache_advice provides advice on cache hit ratios appropriate for the instance workload.

B. The performance of workloads that primarily generate full table scans and fast full index scans are always affected by the cache hit ratio.

C. A 99% cache hit ratio can be observed for database instances which have very poor I/O performance.

D. Both the RECYCLE and KEEP buffer caches should always have a very high cache hit ratio.

E. A 60% cache hit ratio can be observed for database instances which have very good I/O performance.

A. Plan usage data

B. Parent and child latches

C. Enqueue statistics

D. Optimizer execution plans

E. Parent and child latches

F. Segment-level statistics

A. The proportion of WAIT TIME to CPU TIME always increases with increased system load.

B. DB Time accounts for all time used by background processes and user sessions.

C. Parse Time Elapsed accounts for successful soft and hard parse operations only.

D. Statspack cannot account for high CPU time when CPU TIME is a Top 10 event in DB time. When CPU time is high, SQL tuning may improve performance.

E. Systems in which CPU time is dominant need more tuning that those in which WAIT TIME is dominant.

F. When WAIT TIME is high, instance tuning may improve performance.

A. DBMS_STATS.GATHER_DICTIONARY_STATS

B. DBMS_STATS.GATHER_DATABASE_STATS

C. DBMS_STATS.GATHER_SYSTEM_STATS

D. DBMS_STATS.GATHER_FIXED_ OBJECTS_STATS

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

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

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

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

E. When the tuning goal has been met

A. ROW STORE COMPRESS ADVANCED

B. STORE COMPRESS

C. COLUMN STORE COMPRESS FOR QUERY HIGH

D. MN STORE COMPRESS FOR QUERY LOW