Which three are true about monitoring waits for sessions and services?

Correct Answer for the Question – Which three are true about monitoring waits for sessions and services? is given below

Which three are true about monitoring waits for sessions and services? (Choose three.)

V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.

V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.

V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.

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

V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.

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

Correct Answer

The Correct Answer for this Question is

V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.
V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.
V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.

The answers for the certifications of MNCs could be very tricky to understand. that’s why we have solved and pasted these exam answers here. The Question – Which three are true about monitoring waits for sessions and services? has been answered correctly and answers for various other similar questions could be found in the search box of this site.

More about these Exams

These Exam Questions and the order of these questions keep changing. but the answers are obviously same. so if you don’t find a question after another we suggest you search it in the search box and we are sure you’ll find it. you can bookmark this site for Quick access in future.

We hope you found it helpful don’t forget to leave a comment if you feel a need to correct or ask we’re always here to help.

you can find more here at mnccertified

Feel free to contact via comment or email.

Happy Learning

Cheers, Team MNCcertified

Leave a Comment