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.

TRANSACTING, NOT_TRANSACTING, EXCEPTION_HANDLING, CONSTRUCTING, CONSTRUCTED, DECONSTRUCTING, or DECONSTRUCTED

The total number of transactions executed within the session; this number provides a general indication of the level of activity in the session

The total elapsed time in milliseconds in which transactions were being executed

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

0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

我想要获取技术服务或软件
服务范围：MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式：远程服务、电话支持、现场服务，沟通指定方式服务
技术标签：数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题

本站部分文章参考或来源于网络，如有侵权请联系站长。
数据库远程运维 Oracle 视图 V$AW_SESSION_INFO 官方解释，作用，如何使用详细说明