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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29435844/viewspace-1078462/