Oracle8i Reference
Release 2 (8.1.6)

A76961-01

Library

Product

Contents

Index

Prev Up Next

Dynamic Performance (V$) Views, 100 of 179


V$OPEN_CURSOR

This view lists cursors that each user session currently has opened and parsed.

Column  Datatype  Description 

SADDR 

RAW 

Session address 

SID 

NUMBER 

Session identifier 

USER_NAME 

VARCHAR2(30) 

User that is logged in to the session 

ADDRESS  

RAW 

Used with HASH_VALUE to identify uniquely the SQL statement being executed in the session 

HASH_VALUE  

NUMBER 

Used with ADDRESS to identify uniquely the SQL statement being executed in the session 

SQL_TEXT 

VARCHAR2(60) 

First 60 characters of the SQL statement that is parsed into the open cursor 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index