【转】V$SESSION
来源:互联网 发布:c语言计算马德隆常数 编辑:程序博客网 时间:2024/05/17 09:11
This view lists session information for each current session.
SADDR
RAW(4 | 8)
Session addressSID
NUMBER
Session identifierSERIAL#
NUMBER
Session serial number. Used to uniquely identify a session's objects. Guarantees that session-level commands are applied to the correct session objects if the session ends and another session begins with the same session ID.AUDSID
NUMBER
Auditing session IDPADDR
RAW(4 | 8)
Address of the process that owns the sessionUSER#
NUMBER
Oracle user identifierUSERNAME
VARCHAR2(30)
Oracle usernameCOMMAND
NUMBER
Command in progress (last statement parsed); for a list of values, see Table 7-5. These values also appear in the AUDIT_ACTIONS
table.OWNERID
NUMBER
The column contents are invalid if the value is 2147483644
. Otherwise, this column contains the identifier of the user who owns the migratable session.For operations using Parallel Slaves, interpret this value as a 4-byte value. The low-order 2 bytes of which represent the session number, and the high-order bytes the instance ID of the query coordinator.
TADDR
VARCHAR2(8)
Address of transaction state objectLOCKWAIT
VARCHAR2(8)
Address of lock waiting for; null if noneSTATUS
VARCHAR2(8)
Status of the session: ACTIVE
- Session currently executing SQLINACTIVE
KILLED
- Session marked to be killedCACHED
- Session temporarily cached for use by Oracle*XASNIPED
- Session inactive, waiting on the client
SERVER
VARCHAR2(9)
Server type (DEDICATED
| SHARED
| PSEUDO
| NONE
)SCHEMA#
NUMBER
Schema user identifierSCHEMANAME
VARCHAR2(30)
Schema user nameOSUSER
VARCHAR2(30)
Operating system client user namePROCESS
VARCHAR2(12)
Operating system client process IDMACHINE
VARCHAR2(64)
Operating system machine nameTERMINAL
VARCHAR2(30)
Operating system terminal namePROGRAM
VARCHAR2(48)
Operating system program nameTYPE
VARCHAR2(10)
Session typeSQL_ADDRESS
RAW(4 | 8)
Used with SQL_HASH_VALUE
to identify the SQL statement that is currently being executedSQL_HASH_VALUE
NUMBER
Used with SQL_ADDRESS
to identify the SQL statement that is currently being executedSQL_ID
VARCHAR2(13)
SQL identifier of the SQL statement that is currently being executedSQL_CHILD_NUMBER
NUMBER
Child number of the SQL statement that is currently being executedPREV_SQL_ADDR
RAW(4 | 8)
Used with PREV_HASH_VALUE
to identify the last SQL statement executedPREV_HASH_VALUE
NUMBER
Used with SQL_HASH_VALUE
to identify the last SQL statement executedPREV_SQL_ID
VARCHAR2(13)
SQL identifier of the last SQL statement executedPREV_CHILD_NUMBER
NUMBER
Child number of the last SQL statement executedMODULE
VARCHAR2(48)
Name of the currently executing module as set by calling the DBMS_APPLICATION_INFO.SET_MODULE
procedureMODULE_HASH
NUMBER
Hash value of the above MODULE
ACTION
VARCHAR2(32)
Name of the currently executing action as set by calling the DBMS_APPLICATION_INFO.SET_ACTION
procedureACTION_HASH
NUMBER
Hash value of the above action nameCLIENT_INFO
VARCHAR2(64)
Information set by the DBMS_APPLICATION_INFO.SET_CLIENT_INFO
procedureFIXED_TABLE_SEQUENCE
NUMBER
This contains a number that increases every time the session completes a call to the database and there has been an intervening select from a dynamic performance table. This column can be used by performance monitors to monitor statistics in the database. Each time the performance monitor looks at the database, it only needs to look at sessions that are currently active or have a higher value in this column than the highest value that the performance monitor saw the last time. All the other sessions have been idle since the last time the performance monitor looked at the database.ROW_WAIT_OBJ#
NUMBER
Object ID for the table containing the row specified in ROW_WAIT_ROW#
ROW_WAIT_FILE#
NUMBER
Identifier for the datafile containing the row specified in ROW_WAIT_ROW#
. This column is valid only if the session is currently waiting for another transaction to commit and the value of ROW_WAIT_OBJ#
is not -1
.ROW_WAIT_BLOCK#
NUMBER
Identifier for the block containing the row specified in ROW_WAIT_ROW#
. This column is valid only if the session is currently waiting for another transaction to commit and the value of ROW_WAIT_OBJ#
is not -1
.ROW_WAIT_ROW#
NUMBER
Current row being locked. This column is valid only if the session is currently waiting for another transaction to commit and the value of ROW_WAIT_OBJ#
is not -1
.LOGON_TIME
DATE
Time of logonLAST_CALL_ET
NUMBER
If the session STATUS
is currently ACTIVE
, then the value represents the elapsed time in seconds since the session has become active.If the session STATUS
is currently INACTIVE
, then the value represents the elapsed time in seconds since the session has become inactive.
PDML_ENABLED
VARCHAR2(3)
This column has been replaced by column PDML_STATUS
FAILOVER_TYPE
VARCHAR2(13)
Indicates whether and to what extent transparent application failover (TAF) is enabled for the session: NONE
- Failover is disabled for this sessionSESSION
- Client is able to fail over its session following a disconnectSELECT
- Client is able to fail over queries in progress as well
See Also:
Oracle Database Concepts for more information on TAF
Oracle Database Net Services Administrator's Guide for information on configuring TAF
FAILOVER_METHOD
VARCHAR2(10)
Indicates the transparent application failover method for the session: NONE
- Failover is disabled for this sessionBASIC
- Client itself reconnects following a disconnectPRECONNECT
- Backup instance can support all connections from every instance for which it is backed up
FAILED_OVER
VARCHAR2(3)
Indicates whether the session is running in failover mode and failover has occurred (YES
) or not (NO
)RESOURCE_CONSUMER_GROUP
VARCHAR2(32)
Name of the session's current resource consumer groupPDML_STATUS
VARCHAR2(8)
If ENABLED
, the session is in a PARALLEL DML enabled mode. If DISABLED
, PARALLEL DML enabled mode is not supported for the session. If FORCED
, the session has been altered to force PARALLEL DML.PDDL_STATUS
VARCHAR2(8)
If ENABLED
, the session is in a PARALLEL DDL enabled mode. If DISABLED
, PARALLEL DDL enabled mode is not supported for the session. If FORCED
, the session has been altered to force PARALLEL DDL.PQ_STATUS
VARCHAR2(8)
If ENABLED
, the session is in a PARALLEL QUERY enabled mode. If DISABLED
, PARALLEL QUERY enabled mode is not supported for the session. If FORCED
, the session has been altered to force PARALLEL QUERY.CURRENT_QUEUE_DURATION
NUMBER
If queued (1
), the current amount of time the session has been queued. If not currently queued, the value is 0
.CLIENT_IDENTIFIER
VARCHAR2(64)
Client identifier of the sessionBLOCKING_SESSION_STATUS
VARCHAR2(11)
Blocking session status: VALID
NO HOLDER
GLOBAL
NOT IN WAIT
UNKNOWN
BLOCKING_INSTANCE
NUMBER
Instance identifier of blocking sessionBLOCKING_SESSION
NUMBER
Session identifier of blocking sessionSEQ#
NUMBER
Sequence number that uniquely identifies the wait. Incremented for each wait.EVENT#
NUMBER
Event numberEVENT
VARCHAR2(64)
Resource or event for which the session is waitingSee Also: Appendix C, "Oracle Wait Events"
P1TEXT
VARCHAR2(64)
Description of the first additional parameterP1
NUMBER
First additional parameterP1RAW
RAW(4)
First additional parameterP2TEXT
VARCHAR2(64)
Description of the second additional parameterP2
NUMBER
Second additional parameterP2RAW
RAW(4)
Second additional parameterP3TEXT
VARCHAR2(64)
Description of the third additional parameterP3
NUMBER
Third additional parameterP3RAW
RAW(4)
Third additional parameterWAIT_CLASS_ID
NUMBER
Identifier of the wait classWAIT_CLASS#
NUMBER
Number of the wait classWAIT_CLASS
VARCHAR2(64)
Name of the wait classWAIT_TIME
NUMBER
A nonzero value is the session's last wait time. A zero value means the session is currently waiting.SECONDS_IN_WAIT
NUMBER
If WAIT_TIME
= 0
, then SECONDS_IN_WAIT
is the seconds spent in the current wait condition. If WAIT_TIME
> 0
, then SECONDS_IN_WAIT
is the seconds since the start of the last wait, and SECONDS_IN_WAIT
- WAIT_TIME
/ 100
is the active seconds since the last wait ended.STATE
VARCHAR2(19)
Wait state: 0 - WAITING
(the session is currently waiting)-2 - WAITED UNKNOWN TIME
(duration of last wait is unknown)-1 - WAITED SHORT TIME
(last wait <1/100th of a second)>0 - WAITED KNOWN TIME
(WAIT_TIME
= duration of last wait)
SERVICE_NAME
VARCHAR2(64)
Service name of the sessionSQL_TRACE
VARCHAR2(8)
Indicates whether SQL tracing is enabled (ENABLED
) or disabled (DISABLED
)SQL_TRACE_WAITS
VARCHAR2(5)
Indicates whether wait tracing is enabled (TRUE
) or not (FALSE
)SQL_TRACE_BINDS
VARCHAR2(5)
Indicates whether bind tracing is enabled (TRUE
) or not (FALSE
)Table 7-5 COMMAND Column of V$SESSION and Corresponding Commands
1
CREATE TABLE
2
INSERT
3
SELECT
4
CREATE CLUSTER
5
ALTER CLUSTER
6
UPDATE
7
DELETE
8
DROP CLUSTER
9
CREATE INDEX
10
DROP INDEX
11
ALTER INDEX
12
DROP TABLE
13
CREATE SEQUENCE
14
ALTER SEQUENCE
15
ALTER TABLE
16
DROP SEQUENCE
17
GRANT OBJECT
18
REVOKE OBJECT
19
CREATE SYNONYM
20
DROP SYNONYM
21
CREATE VIEW
22
DROP VIEW
23
VALIDATE INDEX
24
CREATE PROCEDURE
25
ALTER PROCEDURE
26
LOCK
27
NO-OP
28
RENAME
29
COMMENT
30
AUDIT OBJECT
31
NOAUDIT OBJECT
32
CREATE DATABASE LINK
33
DROP DATABASE LINK
34
CREATE DATABASE
35
ALTER DATABASE
36
CREATE ROLLBACK SEG
37
ALTER ROLLBACK SEG
38
DROP ROLLBACK SEG
39
CREATE TABLESPACE
40
ALTER TABLESPACE
41
DROP TABLESPACE
42
ALTER SESSION
43
ALTER USER
44
COMMIT
45
ROLLBACK
46
SAVEPOINT
47
PL/SQL EXECUTE
48
SET TRANSACTION
49
ALTER SYSTEM
50
EXPLAIN
51
CREATE USER
52
CREATE ROLE
53
DROP USER
54
DROP ROLE
55
SET ROLE
56
CREATE SCHEMA
57
CREATE CONTROL FILE
59
CREATE TRIGGER
60
ALTER TRIGGER
61
DROP TRIGGER
62
ANALYZE TABLE
63
ANALYZE INDEX
64
ANALYZE CLUSTER
65
CREATE PROFILE
66
DROP PROFILE
67
ALTER PROFILE
68
DROP PROCEDURE
70
ALTER RESOURCE COST
71
CREATE MATERIALIZED VIEW LOG
72
ALTER MATERIALIZED VIEW LOG
73
DROP MATERIALIZED VIEW LOG
74
CREATE MATERIALIZED VIEW
75
ALTER MATERIALIZED VIEW
76
DROP MATERIALIZED VIEW
77
CREATE TYPE
78
DROP TYPE
79
ALTER ROLE
80
ALTER TYPE
81
CREATE TYPE BODY
82
ALTER TYPE BODY
83
DROP TYPE BODY
84
DROP LIBRARY
85
TRUNCATE TABLE
86
TRUNCATE CLUSTER
91
CREATE FUNCTION
92
ALTER FUNCTION
93
DROP FUNCTION
94
CREATE PACKAGE
95
ALTER PACKAGE
96
DROP PACKAGE
97
CREATE PACKAGE BODY
98
ALTER PACKAGE BODY
99
DROP PACKAGE BODY
100
LOGON
101
LOGOFF
102
LOGOFF BY CLEANUP
103
SESSION REC
104
SYSTEM AUDIT
105
SYSTEM NOAUDIT
106
AUDIT DEFAULT
107
NOAUDIT DEFAULT
108
SYSTEM GRANT
109
SYSTEM REVOKE
110
CREATE PUBLIC SYNONYM
111
DROP PUBLIC SYNONYM
112
CREATE PUBLIC DATABASE LINK
113
DROP PUBLIC DATABASE LINK
114
GRANT ROLE
115
REVOKE ROLE
116
EXECUTE PROCEDURE
117
USER COMMENT
118
ENABLE TRIGGER
119
DISABLE TRIGGER
120
ENABLE ALL TRIGGERS
121
DISABLE ALL TRIGGERS
122
NETWORK ERROR
123
EXECUTE TYPE
157
CREATE DIRECTORY
158
DROP DIRECTORY
159
CREATE LIBRARY
160
CREATE JAVA
161
ALTER JAVA
162
DROP JAVA
163
CREATE OPERATOR
164
CREATE INDEXTYPE
165
DROP INDEXTYPE
167
DROP OPERATOR
168
ASSOCIATE STATISTICS
169
DISASSOCIATE STATISTICS
170
CALL METHOD
171
CREATE SUMMARY
172
ALTER SUMMARY
173
DROP SUMMARY
174
CREATE DIMENSION
175
ALTER DIMENSION
176
DROP DIMENSION
177
CREATE CONTEXT
178
DROP CONTEXT
179
ALTER OUTLINE
180
CREATE OUTLINE
181
DROP OUTLINE
182
UPDATE INDEXES
183
ALTER OPERATOR
- 【转】V$SESSION
- v$session
- V$SESSION
- v$session
- V$Session
- V$SESSION
- v$session
- v$process v$session
- oracle系统表v$session、v$sql字段说明(转)
- v$session和V$process
- v$session和v$process
- v$session and v$process
- v$session和v$process
- v$session 和 v$session_wait
- learning v$ view-v$session
- V$SYSTEM_EVENT、V$SESSION_EVENT、V$SESSION_WAIT&V$session、V$WAITSTAT
- Oracle v$session v$mystat v$process
- v$session 和v$process 、v$transaction
- 我的测试历程091228
- Outlook
- 我很累
- epoll usage questions
- sap锁机制简单理解
- 【转】V$SESSION
- DPC函数
- 明天做什么?
- SIGHUP信号与控制终端
- 【转】如何查看oracle sql执行计划
- windows 2003实现文件夹共享
- VirtualMemory重温
- Linux ELF文件装入与执行概述
- hibernate主键:常用Hibernate主键生成策略