A. Oracle SQL Tuning Advisor
B. Database Resource Manager
C. Oracle Scheduler
D. Oracle Automatic Reoptimization
E. Oracle SQL Performance Management
A. 1
B. 52
C. 5
D. 3
A. DB time includes the time spent executing the RMAN backup and restore command.
B. DB time can be many times greater than the elapsed time since the database instance started.
C. DB time is organized as a simple list of statistics and any time period is attributable to only one statistic.
D. DB tine excludes the time spent waiting for a CPU in the operating system run queue.
A. It improves performance for queries joining several tables using bloom filter joins.
B. It does not improve performance for queries using cached results of function evaluations on columns from the same table.
C. It does not improve performance for queries using user-defined virtual column results.
D. It can improve OLTP workload performance by avoiding the use of indexes.
E. It does not require all database data to fit in memory to improve query performance.
F. It does not improve performance for queries that use join groups on columns from different tables.
A. Rows for sessions that are currently waiting have a wait time of 0.
B. Rows for sessions displaying WAITED UNKNOWN TIME in the STATE column indicate that the session is still waiting.
C. Rows for sessions that are not waiting always contain the total wait time since the session started.
D. Rows for sessions that are not waiting might contain the actual wait time for the last event for which they waited.
E. Rows for sessions that are currently waiting have their wait time incremented every microsecond.
A. 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.
B. Parse Time Elapsed accounts for successful soft and hard parse operations only.
C. DB Time accounts for all time used by background processes and user sessions.
D. The proportion of WAIT TIME to CPU TIME always increases with increased system load.
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.
