General Information
Library Note
Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com . Request a Workshop for
your organization today.
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.