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

Stefan

18 days 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

Nu

13 hours ago

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

upvoted 0 times

...

Leonida

18 days ago

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

upvoted 0 times

...

Georgiann

22 days 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

Casandra

9 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

...

Merissa

23 days 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

26 days ago

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

upvoted 0 times

...

Dottie

30 days ago

I think A and C are true.

upvoted 0 times

...