Oracle OCP 19c 认证1Z0-083考试(第21题)

wwwleoocom

于 2021-06-06 17:43:51 发布

阅读量385

点赞数

分类专栏： Oracle 19c OCP-1z0-083（2021）文章标签： oracle 数据库 leetcode docker nginx

本文链接：https://blog.csdn.net/itsaka/article/details/117632667

版权

Oracle 19c OCP-1z0-083（2021）专栏收录该内容

60 篇文章 47 订阅

订阅专栏

A user complains about poor database performance.
You want to verify if the userג€™s session has waited for certain types of I/O activity.
Which view displays all waits waited on by a session at least once?
A. V$SESSION_EVENT
B. V$SESSTAT
C. V$SESSION_WAIT
D. V$SESSION_WAIT_CLASS
E. V$SESSION

The most correct answer is A. V$SESSION_EVENT, but C. V$SESSION_WAIT can displays the current or last wait for each session. https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-SESSION_EVENT.html#GUID-5723D404-83F7-4C8D-8BF2-031B3FFEAAA8 https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/V-SESSION_WAIT.html#GUID-4EDAB293-F3FC-40FE-BC75-4FEE6A4D7705