7.169 V$DB_OBJECT_CACHE
V$DB_OBJECT_CACHE
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. |
|
|
Not used See Also: "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. This column is obsolete and maintained for backward compatibility. |
|
|
Total number of times objects in the namespace were marked invalid because a dependent object was modified |
|
|
Hash value of the object |
|
|
Current lock mode of the object |
|
|
Current pin mode of the object |
|
|
Status of the object |
|
|
Timestamp for the specification of the object |
|
|
Previous timestamp for the specification of the object |
|
|
Total number of times the object has been locked |
|
|
Total number of times the object has been pinned |
|
|
Property of the object. Possible values include |
|
|
Full hash value of the object |
|
|
The ID of the container to which the data pertains. Possible values include:
|
|
|
Container name of the object. The value of this column is |
|
|
Address of the handle for this object |
|
|
Edition name |
See Also:
-
Oracle Database PL/SQL Packages and Types Reference for more information about the
DBMS_SHARED_POOL.KEEP
procedure -
Oracle Database PL/SQL Packages and Types Reference for more information about the
DBMS_SHARED_POOL.MARKHOT
procedure