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 | VARCHAR2(64) | Owner of the object |
| NAME | VARCHAR2(1000) | Name of the object |
| DB_LINK | VARCHAR2(64) | Database link name, if any |
| NAMESPACE | VARCHAR2(28) | Library cache namespace of the object: TABLE/PROCEDURE, BODY, TRIGGER, INDEX, CLUSTER, OBJECT |
| TYPE | VARCHAR2(28) | Type of the object: INDEX, TABLE, CLUSTER, VIEW, SET, SYNONYM, SEQUENCE, PROCEDURE, FUNCTION, PACKAGE, PACKAGE BODY, TRIGGER, CLASS, OBJECT, USER, DBLINK |
| SHARABLE_MEM | NUMBER | Amount of sharable memory in the shared pool consumed by the object |
| LOADS | NUMBER | Number of times the object has been loaded. This count also increases when an object has been invalidated. |
| EXECUTIONS | NUMBER | Not used See Also: "V$SQLAREA" to see actual execution counts |
| LOCKS | NUMBER | Number of users currently locking this object |
| PINS | NUMBER | Number of users currently pinning this object |
| KEPT | VARCHAR2(3) | (YES | NO) Depends on whether this object has been "kept" (permanently pinned in memory) with the PL/SQL procedure DBMS_SHARED_POOL.KEEP |
| CHILD_LATCH | NUMBER | Child latch number that is protecting the object. This column is obsolete and maintained for backward compatibility. |
| INVALIDATIONS | NUMBER | Total number of times objects in the namespace were marked invalid because a dependent object was modified |
No comments:
Post a Comment