Oracle 视图 V$AW_SESSION_INFO 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图V$AW_SESSION_INFO显示多活动会话信息。 其中可以显示出活动会话的hostname, IP Address, Port num, TNS Session ID,等等。
使用方法：
1. 在SQL Plus中运行以下查询，查看当前活动会话信息:
active_session_info.sql
SELECT sid, serial#, username, SQL_ID, hostname, IP_Address, port_num, tns_session_ID, SQLCommand,
SQLSchema
FROM V$AW_SESSION_INFO;
2. 运行另一个查询检测特定的活动会话：
session_info_for_user.sql
SELECT sid, serial#, username, SQL_ID, hostname, IP_Address, port_num, tns_session_ID, SQLCommand,
SQLSchema
FROM V$AW_SESSION_INFO
WHERE username = ‘&username’;
官方英文解释
V$AW_SESSION_INFO provides information about each active session.
A transaction is a single exchange between a client session and Oracle OLAP. Multiple commands can execute within a single transaction.
| Column | Datatype | Description |
|---|---|---|
|
|
|
A unique numeric identifier for a session |
|
|
|
|
|
|
|
TRANSACTING, NOT_TRANSACTING, EXCEPTION_HANDLING, CONSTRUCTING, CONSTRUCTED, DECONSTRUCTING, or DECONSTRUCTED |
|
|
|
The session identifier |
|
|
|
The database user name under which the session opened |
|
|
|
The total number of transactions executed within the session; this number provides a general indication of the level of activity in the session |
|
|
|
The elapsed time in milliseconds of the mostly recently completed transaction |
|
|
|
The total elapsed time in milliseconds in which transactions were being executed |
|
|
|
The average elapsed time in milliseconds to complete a transaction |
|
|
|
The total CPU time in milliseconds used to complete the most recent transaction |
|
|
|
The total CPU time used to execute all transactions in this session; this total does not include transactions that are currently in progress |
|
|
|
The average CPU time to complete a transaction; this average does not include transactions that are currently in progress |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
