Oracle9i Database Reference Release 2 (9.2) Part Number A96536-01 |
|
Dynamic Performance (V$) Views, 45 of 237
This view displays database objects that are cached in the library cache. Objects include tables, indexes, clusters, synonym definitions, PL/SQL procedures and packages, and triggers.
Column | Datatype | Description |
---|---|---|
|
|
Owner of the object |
|
|
Name of the object |
|
|
Database link name, if any |
|
|
Library cache namespace of the object: |
|
|
Type of the object: |
|
|
Amount of sharable memory in the shared pool consumed by the object |
|
|
Number of times the object has been loaded. This count also increases when an object has been invalidated. |
|
|
See: "V$SQLAREA" to see actual execution counts |
|
|
Number of users currently locking this object |
|
|
Number of users currently pinning this object |
|
|
( |
|
|
Child latch number that is protecting the object |
|
![]() Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|