Oracle Database Administration 2022 Certified Professional — Question 15

Which two statements are true about session wait information contained in v$session or v$session_wait? (Choose two.)

Answer options

• A. Rows for sessions displaying WAITED UNKNOWN TIME in the STATE column indicate that the session is still waiting.
• B. Rows for sessions that are currently waiting have a wait time of 0.
• C. Rows for sessions that are not waiting might contain the actual wait time for the last event for which they waited.
• D. Rows for sessions that are currently waiting have their wait time incremented every microsecond. Rows for sessions that are not waiting always contain the total wait time since the session started.

Correct answer: B, C

Explanation

Option B is correct because sessions that are currently waiting will report a wait time of 0 until they actually enter a wait state. Option C is also correct as sessions that are not waiting can still show the last recorded wait time. The other options are incorrect because they misstate the behavior of sessions in terms of their wait states and times.