SESSIONS

Monitors external sessions. 监控外部会话。

图例

• ✅ = 字段存在于该版本
• ❌ = 字段不存在于该版本
• 备注列标注首次出现或类型变更的版本

字段名	Data Type	11.0.x	11.1.x	12.0.x	23.3.x	23.4.x	24.1.x	24.2.x	24.3.x	24.4.x	25.1.x	25.2.x	25.3.x	25.4.x	26.1.x	26.2.x	备注
AUTHENTICATION_ METHOD	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
CLIENT_ AUTHENTICATION	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
CLIENT_AUTHENTICATION_NAME	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
CLIENT_HOSTNAME	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
CLIENT_LABEL	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
CLIENT_OS	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
CLIENT_OS_HOSTNAME	VARCHAR	✅	❌	❌	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
CLIENT_OS_USER _NAME	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
CLIENT_PID	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
CLIENT_TYPE	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
CLIENT_VERSION	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
CURRENT_STATEMENT	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
EFFECTIVE_PROTOCOL	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
EXTERNAL_MEMORY_KB	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
GRACE_PERIOD	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
IDLE_SESSION_TIMEOUT	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
LAST_STATEMENT	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
LAST_STATEMENT_DURATION_US	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
LOGIN_TIMESTAMP	TIMESTAMP	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
NODE_NAME	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
REQUESTED_PROTOCOL	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
RUNTIME_PRIORITY	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
SESSION_ID	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
SSL_STATE	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
STATEMENT_ID	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
STATEMENT_START	TIMESTAMP	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
TRANSACTION _DESCRIPTION	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
TRANSACTION_ID	INTEGER	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
TRANSACTION_START	DATE	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅
USER_NAME	VARCHAR	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅	✅