Oracle9i Database Reference Release 1 (9.0.1) Part Number A90190-02 |
|
Dynamic Performance (V$) Views, 42 of 211
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 |
|
|
( |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|