Oracle Exam 1Z0-083 Topic 9 Question 86 Discussion

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

Question #: 86
Topic #: 9

Choose two. Which two are true about monitoring waits for sessions and services?

AV$SERVICE_EVENT displays wait counts for every wait event for each service even including counts of zero for waits that never occurred.

BV$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.

CV$SESSION_WAIT and V$SESSION both contain details of the event on which a waiting session is currently waiting.

DV$SESSION_EVENT displays all waits events for those events that have occurred at least once for sessions that have now terminated.

EV$SESSION_WAIT_CLASS displays waits broken down by wait class only for terminated sessions.

Show Suggested Answer

Suggested Answer: C, E

by Candida at Feb 13, 2024, 11:48 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Skye

1 months ago

A and C make the most sense to me. The other options seem a bit sketchy, like the database is trying to hide something from us. Maybe it's just got stage fright and doesn't want to show us all its wait events!

upvoted 0 times

Josphine

2 days ago

Yeah, A and C make the most sense. The other options do seem a bit suspicious.

upvoted 0 times

...

Lashawn

18 days ago

I agree, A and C seem to be the most relevant options for monitoring waits.

upvoted 0 times

...

Maybelle

19 days ago

I think A and C are correct. They provide details about waiting sessions and services.

upvoted 0 times

...

Stefan

2 months ago

Hmm, this is a tricky one. I'll go with A and C, they sound the most accurate to me. Although, if I was the Oracle database, I'd probably be waiting for the exam to be over too!

upvoted 0 times

Teri

1 months ago

User 2: I agree, C is also true because it shows details of the event a waiting session is currently waiting on.

upvoted 0 times

...

Nu

2 months ago

User 1: I think A is correct because it shows wait counts for every event for each service.

upvoted 0 times

...

Leonida

2 months ago

I'm not sure about A, but I think C is definitely true.

upvoted 0 times

...

Georgiann

2 months ago

I'm not sure about B, since it talks about 'last waited' events, not current waiting events. And D and E seem a bit off, mentioning terminated sessions instead of active ones.

upvoted 0 times

Albert

24 days ago

A) V$SERVICE_EVENT displays wait counts for every wait event for each service even including counts of zero for waits that never occurred.

upvoted 0 times

...

Idella

28 days ago

B) V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.

upvoted 0 times

...

Beatriz

29 days ago

C) V$SESSION_WAIT and V$SESSION both contain details of the event on which a waiting session is currently waiting.

upvoted 0 times

...

Casandra

2 months ago

A) V$SERVICE_EVENT displays wait counts for every wait event for each service even including counts of zero for waits that never occurred.

upvoted 0 times

...

Merissa

2 months ago

A and C seem to be the correct answers here. V$SERVICE_EVENT would show wait counts for each service, and V$SESSION_WAIT and V$SESSION have the current wait event details for waiting sessions.

upvoted 0 times

...

Ma

3 months ago

I agree with Dottie. A and C make sense to me too.

upvoted 0 times

...

Dottie

3 months ago

I think A and C are true.

upvoted 0 times

...