ITPub博客

首页 > 数据库 > Oracle > OCP-IZO-053_QUESTION344

OCP-IZO-053_QUESTION344

原创 Oracle 作者:DB_SUN 时间:2014-02-09 17:14:39 0 删除 编辑

QUESTION NO: 344 

In what view are you likely to see the following output? 

SID SERIAL# EVENT SECONDS_IN_WAIT

121 269 RMAN backup & recovery I/O 2

129 415 SQL*Net message from client 63 130 270 SQL*Net message from client

A. V$SESSION_EVENT

B. V$SESSION

C .  V$WAITS

D . V$WAITSTAT 

E.   V$SYSSTAT 

 

【题目示意】

此题考查有关于V$SESSION的相关知识。

【解析】

    V$session 的动态性能视图中会显示当前会话的基本信息。

【实验】

1)V$SESSION可以查询的基本信息。

SYS@ENMOEDU > desc v$session;

 Name                                      Null?    Type

 ------------------------------------------------------------------------

 SADDR                                              RAW(4)

 SID                                                NUMBER

 SERIAL#                                            NUMBER

 AUDSID                                             NUMBER

 PADDR                                              RAW(4)

 USER#                                              NUMBER

 USERNAME                                           VARCHAR2(30)

 COMMAND                                            NUMBER

 OWNERID                                            NUMBER

 TADDR                                              VARCHAR2(8)

 LOCKWAIT                                           VARCHAR2(8)

 STATUS                                             VARCHAR2(8)

 SERVER                                             VARCHAR2(9)

 SCHEMA#                                            NUMBER

 SCHEMANAME                                         VARCHAR2(30)

 OSUSER                                             VARCHAR2(30)

 PROCESS                                            VARCHAR2(24)

 MACHINE                                            VARCHAR2(64)

 PORT                                               NUMBER

 TERMINAL                                           VARCHAR2(30)

 PROGRAM                                            VARCHAR2(48)

 TYPE                                               VARCHAR2(10)

 SQL_ADDRESS                                        RAW(4)

 SQL_HASH_VALUE                                     NUMBER

 SQL_ID                                             VARCHAR2(13)

 SQL_CHILD_NUMBER                                   NUMBER

 SQL_EXEC_START                                     DATE

 SQL_EXEC_ID                                        NUMBER

 PREV_SQL_ADDR                                      RAW(4)

 PREV_HASH_VALUE                                    NUMBER

 PREV_SQL_ID                                        VARCHAR2(13)

 PREV_CHILD_NUMBER                                  NUMBER

 PREV_EXEC_START                                    DATE

 PREV_EXEC_ID                                       NUMBER

 PLSQL_ENTRY_OBJECT_ID                              NUMBER

 PLSQL_ENTRY_SUBPROGRAM_ID                          NUMBER

 PLSQL_OBJECT_ID                                    NUMBER

 PLSQL_SUBPROGRAM_ID                                NUMBER

 MODULE                                             VARCHAR2(64)

 MODULE_HASH                                        NUMBER

 ACTION                                             VARCHAR2(64)

 ACTION_HASH                                        NUMBER

 CLIENT_INFO                                        VARCHAR2(64)

 FIXED_TABLE_SEQUENCE                               NUMBER

 ROW_WAIT_OBJ#                                      NUMBER

 ROW_WAIT_FILE#                                     NUMBER

 ROW_WAIT_BLOCK#                                    NUMBER

 ROW_WAIT_ROW#                                      NUMBER

 TOP_LEVEL_CALL#                                    NUMBER

 LOGON_TIME                                         DATE

 LAST_CALL_ET                                       NUMBER

 PDML_ENABLED                                       VARCHAR2(3)

 FAILOVER_TYPE                                      VARCHAR2(13)

 FAILOVER_METHOD                                    VARCHAR2(10)

 FAILED_OVER                                        VARCHAR2(3)

 RESOURCE_CONSUMER_GROUP                            VARCHAR2(32)

 PDML_STATUS                                        VARCHAR2(8)

 PDDL_STATUS                                        VARCHAR2(8)

 PQ_STATUS                                          VARCHAR2(8)

 CURRENT_QUEUE_DURATION                             NUMBER

 CLIENT_IDENTIFIER                                  VARCHAR2(64)

 BLOCKING_SESSION_STATUS                            VARCHAR2(11)

 BLOCKING_INSTANCE                                  NUMBER

 BLOCKING_SESSION                                   NUMBER

 FINAL_BLOCKING_SESSION_STATUS                      VARCHAR2(11)

 FINAL_BLOCKING_INSTANCE                            NUMBER

 FINAL_BLOCKING_SESSION                             NUMBER

 SEQ#                                               NUMBER

 EVENT#                                             NUMBER

 EVENT                                              VARCHAR2(64)

 P1TEXT                                             VARCHAR2(64)

 P1                                                 NUMBER

 P1RAW                                              RAW(8)

 P2TEXT                                             VARCHAR2(64)

 P2                                                 NUMBER

 P2RAW                                              RAW(8)

 P3TEXT                                             VARCHAR2(64)

 P3                                                 NUMBER

 P3RAW                                              RAW(8)

 WAIT_CLASS_ID                                      NUMBER

 WAIT_CLASS#                                        NUMBER

 WAIT_CLASS                                         VARCHAR2(64)

 WAIT_TIME                                          NUMBER

 SECONDS_IN_WAIT                                    NUMBER

 STATE                                              VARCHAR2(19)

 WAIT_TIME_MICRO                                    NUMBER

 TIME_REMAINING_MICRO                               NUMBER

 TIME_SINCE_LAST_WAIT_MICRO                         NUMBER

 SERVICE_NAME                                       VARCHAR2(64)

 SQL_TRACE                                          VARCHAR2(8)

 SQL_TRACE_WAITS                                    VARCHAR2(5)

 SQL_TRACE_BINDS                                    VARCHAR2(5)

 SQL_TRACE_PLAN_STATS                               VARCHAR2(10)

 SESSION_EDITION_ID                                 NUMBER

 CREATOR_ADDR                                       RAW(4)

 CREATOR_SERIAL#                                    NUMBER

 ECID                                               VARCHAR2(64)

 

2)查询v$session中的SID SERIAL# EVENT SECONDS_IN_WAIT

SYS@ENMOEDU > select SID, SERIAL#, EVENT,SECONDS_IN_WAIT from v$session;

 

       SID    SERIAL# EVENT                         SECONDS_IN_WAIT

---------- ---------- ---------------------------------------------------------------- ---------------

         1          1 pmon timer                                      0

         2          1 VKTM Logical Idle Wait                          456

         3          1 DIAG idle wait                                   1

         4          1 DIAG idle wait                                  0

         5          1 rdbms ipc message                                2

         6          1 rdbms ipc message                                2

         7          1 rdbms ipc message                                393

         8          1 rdbms ipc message                                  0

         9          3 rdbms ipc message                                  112

        10          1 rdbms ipc message                                  50

        12          1 Streams AQ: qmn coordinator idle wait              7

        13         47 rdbms ipc message                                  0

        16          5 Streams AQ: qmn slave idle wait                    7

        18         15 SQL*Net message from client                        3

        19         25 jobq slave wait                                    0

        20         13 RMAN backup & recovery I/O                         0

       125          5 SQL*Net message from client                        0

       126          1 rdbms ipc message                                  0

       127          1 rdbms ipc message                                  2

       128          1 rdbms ipc message                                 2

       129          1 rdbms ipc message                                  2

       130          1 rdbms ipc message                                  2

       131          1 smon timer                                         108

       132          1 SGA: allocation forcing component growth           0

       133         15 rdbms ipc message                                  5

       135          3 rdbms ipc message                                  110

       136          3 rdbms ipc message                                  110

       140         27 Space Manager: slave idle wait                      0

       141          3 Streams AQ: waiting for time management or cleanup tasks  399

       142         11 SQL*Net message from client                         0

       144          5 jobq slave wait                                     0

 

31 rows selected.

 

【小结】

可以看出v$session中参数有很多,SID, SERIAL#, EVENT ,SECONDS_IN_WAIT都可以在v$session中找到,因此选择B。

【答案】 B

 

相关参考

file:///D:/oracle/11g手册_01/server.112/e40402/dynviews_3016.htm#i1414383

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29435844/viewspace-1078462/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2014-01-14

  • 博文量
    41
  • 访问量
    190529