在本视图中,每一个连接到数据库实例中的session都拥有一条记录。包括用户session及后台进程如DBWR,LGWR,arcchiver等等。
V$SESSION 中的常用列
V$SESSION 是基础信息视图,用于找寻用户SID或SADDR。不过,它也有一些列会动态的变化,可用于检查用户。如例:
字段解释:
字段1:SARRD: raw(4):Session Address,session的地址
字段2:SID:RAW(4):Session Identifier,session的标识符
字段3:SERIAL# :NUMBER:
Session serial number,Session的序列号。 Used to identify uniquely 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
如果某个SID又被其它的session使用的话则此数值自增加(当一个 SESSION 结束,另一个SESSION开始并使用了同一个SID)。
字段4:AUDSID:number:Auditing session ID
审查session ID唯一性,确认它通常也用于当寻找并行查询模式。
字段5:PARRD:RAW(4):Address of the process that owns this session
这个session拥有的进程地址
字段6:USER#:number:Oracle user identified
Oracle用户的标识符
字段7:USERNAME:varchar2(30):Oracle username,Oracle的用户名
字段8:COMMAND:number:
Command in progress (last statement parsed); for a list of values, see Table 3-7
该session 的命令所对应的sql对应数字值:默认为0
字段8: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 4Byte value. The low-order 2Bytes of which represent the session number, and the high-order bytes the instance ID of the query coordinator
字段9:TADDR:VARCHAR2(8) :Address of transaction state object
事务状态对象的地址
字段10:LOCKWAIT :VARCHAR2(8)
Address of lock waiting for; NULL if none
锁等待的地址,如果为空的话则没有等待
字段11:STATUS :VARCHAR2(8)
Status of the session: ACTIVE (currently executing SQL), INACTIVE, KILLED (marked to be killed), CACHED (temporarily cached for use by Oracle*XA), SNIPED (session inactive, waiting on the client)
这列用来判断session状态是:
Active :活动状态,正执行SQL语句
Inactive :不活动状态
Killed :被标注为删除
Cached:Oracle中的临时缓冲区使用
SNIPED:session不活动,等待客户端操作
字段12:SERVER :VARCHAR2(9)
Server type: DEDICATED, SHARED, PSEUDO, NONE
使用连接数据库服务器的类型
DEDICATED:专用服务器
SHARED:共享服务器
PSEUDO:
NONE:
字段13:SCHEMA# :NUMBER :
Schema user identifier
Schema 用户标识符所对应的数字值
字段14:SCHEMANAME :VARCHAR2(30) :
Schema user name
Schema的用户名
字段15:OSUSER :VARCHAR2(15)
Operating system client user name
客户端操作系统的用户名
字段16:PROCESS
VARCHAR2(9)
Operating system client process ID
客户端操作系统的进程ID(标识符)
字段17:MACHINE
VARCHAR2(64)
Operating system machine name
连接数据库的客户端操作系统的机器名称
字段18:TERMINAL
VARCHAR2(10)
Operating system terminal name
连接数据库的客户端操作系统的终端名称
字段19:PROGRAM
VARCHAR2(48)
Operating system program name
连接数据库的客户端操作系统的进程名称
字段20:TYPE
VARCHAR2(10)
Session type
Session的类型
字段21:SQL_ADDRESS
RAW(4)
Used with SQL_HASH_VALUE to identify the SQL statement that is currently being executed
当前正在执行的SQL语句的SQL_HASH_VALUE值
字段22:SQL_HASH_VALUE
NUMBER
Used with SQL_ADDRESS to identify the SQL statement that is currently being executed
当前正在执行的SQL语句的SQL_ADDRESS值
SQL_HASH_VALUE ,SQL_ADDRESS:这两列用于鉴别默认被session执行的SQL语句。如果为null或0,那就说明这个session没有执行任何SQL语句。PREV_HASH_VALUE和PREV_ADDRESS两列用来鉴别被session执行的上一条语句。
字段23:SQL_ID
VARCHAR2(13)
SQL identifier of the SQL statement that is currently being executed
正在执行的SQL语句的标识符
字段24:SQL_CHILD_NUMBER
number
Child number of the SQL statement that is currently being executed
字段25:PREV_SQL_ADDR
raw(4)
Used with PREV_HASH_VALUE to identify the last SQL statement executed
字段26:PREV_HASH_VALUE
Number
Used with SQL_HASH_VALUE to identify the last SQL statement executed
字段27:PREV_SQL_ID
Varchar2(13)
SQL identifier of the last SQL statement executed
Table 7-5 COMMAND Column of V$SESSION and Corresponding Commands
Number | Command | Number | Command |
---|---|---|---|
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 |
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12778571/viewspace-588832/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12778571/viewspace-588832/