Note
This view is introduced in V4.2.5 BP6 of OceanBase Database V4.2.x.
Description
The DBA_OB_PL_OBJ_CACHE_STATUS view is used to display the status of PL cache objects.
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| OBJECT_NAME | VARCHAR2(128) | NO | The name of the PL object |
| OBJECT_ID | NUMBER(38) | NO | The ID of the PL object |
| OBJECT_TYPE | VARCHAR2(12) | NO | The type of the PL object |
| STATUS | VARCHAR2(7) | NO | The status of the PL object |
| COMPILE_DB_ID | NUMBER(38) | NO | The db_id during the PL compilation |
| DISK_CACHE_STATUS | VARCHAR2(32767) | NO | The status of the PL object in the disk cache |
| PL_CACHE_STATUS | VARCHAR2(32767) | NO | The status of the PL object in the PL cache |
Examples
Query the status of PL cache objects.
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)