Oracle Database 12c: Performance Management and Tuning — Question 15

Which two statements are true about DB time in V$SYS_TIME_MODEL? (Choose two.)

Answer options

• A. DB time cannot exceed the total elapsed time (walk clock time) since the database instance started.
• B. DB time cannot exceed the maximum number of concurrent sessions multiplied by the actual elapsed time for each session.
• C. DB time includes the time spent on client processes and background processes.
• D. Reducing DB time allows a database instance to support more user requests by using the same resources.
• E. DB time is always greater than or equal to the DB CPU time.

Correct answer: D, E

Explanation

The correct answer is D and E because reducing DB time enhances the ability of a database instance to handle additional user requests efficiently without increasing resource usage, while DB time is inherently designed to be greater than or equal to the DB CPU time, as it accounts for all time spent processing requests. Options A, B, and C are incorrect as they either misrepresent the limitations of DB time or include irrelevant details about client and background processes.