Skip Headers

Oracle9i Database Reference
Release 2 (9.2)
Part Number A96536-02
Go to Documentation Home
Home		 Go to Book List
Book List		 Go to Table of Contents
Contents		 Go to Index
Index		 Go to Master Index
Master Index		 Go to Feedback page
Feedback
Go to previous page Go to next page
View PDF

V$SYSTEM_CURSOR_CACHE

This view displays similar information to the V$SESSION_CURSOR_CACHE view except that this information is system wide.

See Also:

"V$SESSION_CURSOR_CACHE"
Column Datatype Description

OPENS

NUMBER

Cumulative total of cursor opens

HITS

NUMBER

Cumulative total of cursor open hits

HIT_RATIO

NUMBER

Ratio of the number of times you found an open cursor divided by the number of times you looked for a cursor
Go to previous page Go to next page
Oracle
Copyright © 1996, 2002 Oracle Corporation.
All Rights Reserved.
Go to Documentation Library
Home		 Go to Product List
Book List		 Go to Table of Contents
Contents		 Go to Index
Index		 Go to Master Index
Master Index		 Go to Feedback page
Feedback