Oracle8i Reference
Release 2 (8.1.6)

Part Number A76961-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

Dynamic Performance (V$) Views, 129 of 179


V$ROWCACHE

This view displays statistics for data dictionary activity. Each row contains statistics for one data dictionary cache.

Column  Datatype  Description 

CACHE# 

NUMBER 

Row cache ID number 

TYPE 

VARCHAR2 

Parent or subordinate row cache type 

SUBORDINATE# 

NUMBER 

Subordinate set number 

PARAMETER  

VARCHAR2 

Name of the initialization parameter that determines the number of entries in the data dictionary cache 

COUNT 

NUMBER 

Total number of entries in the cache 

USAGE  

NUMBER 

Number of cache entries that contain valid data 

FIXED 

NUMBER 

Number of fixed entries in the cache 

GETS  

NUMBER 

Total number of requests for information on the data object 

GETMISSES  

NUMBER 

Number of data requests resulting in cache misses 

SCANS 

NUMBER 

Number of scan requests 

SCANMISSES  

NUMBER 

Number of times a scan failed to find the data in the cache 

SCANCOMPLETES  

NUMBER 

For a list of subordinate entries, the number of times the list was scanned completely 

MODIFICATIONS 

NUMBER 

Number of inserts, updates, and deletions 

FLUSHES 

NUMBER 

Number of times flushed to disk 

DLM_REQUESTS 

NUMBER 

The number of DLM requests 

DLM_CONFLICTS 

NUMBER 

The number of DLM conflicts 

DLM_RELEASES 

NUMBER 

The number of DLM releases 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index