| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
Supporting utility for Database In-Memory |
| AUTHID |
DEFINER |
| Dependencies |
| ALL_OBJECTS |
DBMS_INMEMORY_ADMIN |
GV_$ACTIVE_SERVICES |
| ALL_OBJECT_TABLES |
DBMS_LOCK |
GV_$IM_SEGMENTS |
| DBA_TABLES |
DBMS_OUTPUT |
GV_$INSTANCE |
| DBA_TAB_PARTITIONS |
DBMS_SPACE |
PG$ |
| DBA_TAB_SUBPARTITIONS |
DBMS_STANDARD |
V_$IM_GRAPH_TOPOLOGY |
| DBMS_INMEMORY |
DBMS_SYSTEM |
V_$PARAMETER |
|
| Documented |
No |
| First Available |
19c |
| Security Model |
Owned by SYS with EXECUTE granted to the DBA role |
| Source |
{ORACLE_HOME}/rdbms/admin/prvtinmemadmin.plb |
| Subprograms |
|
| |
| POPULATE_WAIT |
Undocumented
The first line returned was from dbms_output and correctly indicates that an in-memory area does not exist. The second value is the returned parameter |
prvt_dbms_inmemory_admin.populate_wait(
priority IN VARCHAR2,
percentage IN NUMBER,
timeout IN NUMBER,
force IN BOOLEAN)
RETURN NUMBER; |
DECLARE
retVal NUMBER;
BEGIN
retVal := prvt_dbms_inmemory_admin.populate_wait('HIGH',90, 10, FALSE);
dbms_output.put_line(retVal);
END;
/
POPULATE ERROR, INMEMORY_SIZE=0
3
PL/SQL procedure successfully completed. |