Oracle 1Z0-084 Exam - Topic 15 Question 43 Discussion

Actual exam question for Oracle's 1Z0-084 exam

Question #: 43
Topic #: 15

[All 1Z0-084 Questions]

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

ERows for sessions that are not waiting always contain the total wait time since the session started.

BRows for sessions that are currently waiting have a wait time of 0.

ARows for sessions displaying WAITED UNKNOWN TIME in the STATE column indicate that the session is still waiting.

DRows for sessions that are currently waiting have their wait time incremented every microsecond.

CRows for sessions that are not waiting might contain the actual wait time for the last event for which they waited.

Show Suggested Answer

Suggested Answer: B, C

In the V$SESSION view, Oracle provides information about the session waits:

B) When the WAIT_TIME column has a value of 0, it signifies that the session is currently waiting for a resource. This column represents the duration of the current or last wait.

C) If the session is not actively waiting, the WAIT_TIME column shows the time the session spent waiting for the last wait event. If the STATE column is showing 'WAITED KNOWN TIME', it means the session is not currently waiting, but it indicates the time for which it had waited.

Oracle Database Reference, 19c

Oracle Database Performance Tuning Guide, 19c

by Earlean at Jan 26, 2026, 05:12 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-084 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Hyman

3 days ago

I’m a bit confused; I think v$session_wait is more about the wait state, while v$session has broader session details, but I need to double-check that.

upvoted 0 times

...

Jules

8 days ago

I practiced a similar question where we had to identify wait events, and I feel like one of the statements might be about wait types being categorized.

upvoted 0 times

...

Lajuana

1 month ago

I think both views provide insights into session activity, but I can't recall the specific differences in the information they present.

upvoted 0 times

...

Youlanda

1 month ago

I remember something about v$session_wait showing the current wait event, but I'm not entirely sure how it relates to v$session.

upvoted 0 times

...

Essie

1 month ago

Hmm, I'm not too familiar with these particular views. But I'll take my time, read through the question carefully, and try to reason through the options logically. Hopefully, I can at least eliminate the clearly wrong ones.

upvoted 0 times

...

Bernardine

2 months ago

No problem, I've got this. I've worked with these views before, so I know the kind of information they contain. I'll just need to carefully read through the options and select the two that are accurate based on my experience.

upvoted 0 times

...

Santos

2 months ago

Wait, I'm a bit confused. Do I need to know the specific details of what's in those views, or can I just make an educated guess based on my general understanding of sessions and waits? I'm not sure I have time to dive deep into the documentation.

upvoted 0 times

...

Kris

2 months ago

Okay, I think I've got a handle on this. The key is to identify the two true statements from the options provided. I'll methodically go through each one and evaluate whether it matches the information in the system views.

upvoted 0 times

...

Melinda

2 months ago

Hmm, this seems like a tricky one. I'll need to carefully review the documentation on v$session and v$session_wait to make sure I understand the key points about the session wait information they contain.

upvoted 0 times

...