介绍

V$OPEN_CURSOR视图提供了查询每个用户会话已打开的(或缓存、解析)游标情况的方法。

视图详情

下面列表信息来源于Oracle 11G官方文档，本人仅做简单翻译，方便下次查询。

字段名	字段类型	描述	译	备注
SADDR	RAW(4 | 8)	Session address	会话的地址	可以与V$SESSION视图的SADDR列关联查询
SID	NUMBER	Session identifier	会话标识符	可以与V$SESSION视图的SID列关联查询
USER_NAME	VARCHAR2(30)	User that is logged in to the session	使用会话的用户名
ADDRESS	RAW(4 | 8)	Used with HASH_VALUE to uniquely identify the SQL statement being executed in the session	与HASH_VALUE列一起可以唯一标识在会话中执行的SQL语句
HASH_VALUE	NUMBER	Used with ADDRESS to uniquely identify the SQL statement being executed in the session	与ADDRESS列一起可以唯一标识在会话中执行的SQL语句
SQL_ID	VARCHAR2(13)	SQL identifier of the SQL statement being executed in the session	在会话中执行的SQL语句的SQL标识符
SQL_TEXT	VARCHAR2(60)	First 60 characters of the SQL statement that is parsed into the open cursor	游标中执行的SQL的前60个字符
LAST_SQL_ACTIVE_TIME	DATE	Time when this cursor was last executed	游标最后一次执行的时间
SQL_EXEC_ID	NUMBER	If the open cursor is executing, then the SQL execution identifier for that execution (see V$SQL_MONITOR)	如果游标正在执行，则显示SQL执行标识符。
CURSOR_TYPE	VARCHAR2(64)	Type of cursor: OPEN-PL/SQL - Open PL/SQL cursors OPEN - Other open cursors SESSION CURSOR CACHED - Cursors cached in the generic session cursor cache OPEN-RECURSIVE - Open recursive cursors DICTIONARY LOOKUP CURSOR CACHED - Cursor cached in the dictionary lookup cursor cache BUNDLE DICTIONARY LOOKUP CACHED - Cursors cached in the bundled dictionary lookup cursor cache JAVA NAME TRANSLATION CURSOR CACHED - Cursors cached in the Java name translation cursor cache REPLICATION TRIGGER CURSOR CACHED - Cursors cached in the replication trigger cursor cache CONSTRAINTS CURSOR CACHED - Cursors cached in the constraints cursor cache PL/SQL CURSOR CACHED - Cursors cached in the PL/SQL cursor cache		这里暂不翻译，待后续测试