Oracle8i Reference Release 2 (8.1.6) Part Number A76961-01 |
|
Dynamic Performance (V$) Views, 39 of 179
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 |
|
|
YES or NO, depending on whether this object has been "kept" (permanently pinned in memory) with the PL/SQL procedure |
|
![]() Copyright © 1996-2000, Oracle Corporation. All Rights Reserved. |
|