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
DBA_TABLES
DBMS_LOCK
GV_$ACTIVE_SERVICES
DBA_TAB_PARTITIONS
DBMS_OUTPUT
GV_$IM_SEGMENTS
DBA_TAB_SUBPARTITIONS
DBMS_SPACE
GV_$INSTANCE
DBMS_INMEMORY
DBMS_STANDARD
V_$PARAMETER
DBMS_INMEMORY_ADMIN
DBMS_SYSTEM
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.