Note
For V4.2.x versions, this view is available starting from V4.2.5 BP6.
Overview
The DBA_OB_PL_OBJ_CACHE_STATUS view displays the status information of PL cache objects.
Columns
Field |
Type |
Nullable |
Description |
|---|---|---|---|
| OBJECT_NAME | VARCHAR2(128) | NO | PL object name |
| OBJECT_ID | NUMBER(38) | NO | PL Object ID |
| OBJECT_TYPE | VARCHAR2(12) | NO | PL Object Types |
| STATUS | VARCHAR2(7) | NO | PL Object Status |
| COMPILE_DB_ID | NUMBER(38) | NO | PL Compilation Phase Corresponding todb_id |
| DISK_CACHE_STATUS | VARCHAR2(32767) | NO | The status of PL objects in the disk cache. |
| PL_CACHE_STATUS | VARCHAR2(32767) | NO | Status of PL objects in the PL cache |
Sample query
Query Description
obclient [SYS]> SELECT * FROM DBA_OB_PL_OBJ_CACHE_STATUS WHERE rownum < 2\G
The query result is as follows:
*************************** 1. row ***************************
OBJECT_NAME: DBMS_OUTPUT
OBJECT_ID: 310013
OBJECT_TYPE: PACKAGE BODY
STATUS: VALID
COMPILE_DB_ID: NULL
DISK_CACHE_STATUS: NOT IN DISK CACHE
PL_CACHE_STATUS: NOT IN PL CACHE
1 row in set (0.057 sec)