Oracle | Persistent Memory Database

Oracle Persistent Memory Database Version 20c

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 The persistent memory filestore is a new 20c feature intended the greatly expand the ability of the Oracle Database to operate as an in-memory database with its associated performance without losing the security associated with persisting transactions on non-volatile storage.

The Persistent Memory Database accomplishes this by ....

First Available 20c

System Privileges SYSDBA is required to create, alter or drop a Persistent Memory Database

Object Privileges None

PMEM_FILESTORE

Default: <none defined> Specifies the Persistent Memory Filestore that mounted automatically at instance startup
Syntax: pmem_filestore=('mount_point', 'backing_file' [,'mount_point', 'backing_file', ....]}

ALTER SYSTEM SET pmem_filestore=('/u03/oracle/pmemfs/perfile1','/u04oracle/pmembf/bakfile1')

      SID='*'

      SCOPE = spfile;

Dependencies

CDB_	DBA_	GV$

Create (new 20c)

Create a Persistent Memory Database CREATE PMEM FILESTORE <filestore_name> MOUNTPOINT '<path_and_file_name>' BACKINGFILE '<path_and_backing_file_name>' [REUSE] SIZE <integer> <M | G | T> BLOCK SIZE <2 | 4 | 8 | 16 | 32>K AUTOEXTEND ON NEXT <integer> <K | M | G | T> MAXSIZE <integer> <K | M | G | T>;

SQL> conn / as sysdba

      

      SQL> show con_id

      

       CON_ID

      -------

      1

      

      SQL> show con_name

      

      CON_NAME

      ---------

      CDB$ROOT

      

      SELECT file_name FROM dba_data_files;

      

      FILE_NAME

      ------------------------------------------------------------

      +DATA/TEST21DB_IAD25G/DATAFILE/undotbs1.263.1058897159

      +DATA/TEST21DB_IAD25G/DATAFILE/system.261.1058897079

      +DATA/TEST21DB_IAD25G/DATAFILE/sysaux.262.1058897143

      +DATA/TEST21DB_IAD25G/DATAFILE/users.276.1058898329

      

      SELECT member FROM v$logfile;

      

      MEMBER

      -------------------------------------------------------

      +RECO/TEST21DB_IAD25G/ONLINELOG/group_3.259.1058897199

      +RECO/TEST21DB_IAD25G/ONLINELOG/group_2.258.1058897199

      +RECO/TEST21DB_IAD25G/ONLINELOG/group_1.257.1058897199

      

      CREATE PMEM FILESTORE uw_pmfs

      MOUNTPOINT '+DATA/TEST21DB_IAD25G/DATAFILE/perfile1'

      BACKINGFILE '+RECO/TEST21DB_IAD25G/ONLINELOG/bakfile1'

      SIZE 500M

      -- BLOCK SIZE 8K

      AUTOEXTEND ON NEXT 25M

      MAXSIZE 1G;

      CREATE PMEM FILESTORE uw_pmfs

      *

      ERROR at line 1:

      ORA-12755: Feature PMEM FILESTORE is disabled due to unsupported 
      capability.

      

      

      CREATE PMEM FILESTORE uw_pmfs

      MOUNTPOINT '/u03/oracle/pmemfs/perfile1'

      BACKINGFILE '/u04oracle/pmembf/bakfile1'

      SIZE 500G

      BLOCK SIZE 8K

      AUTOEXTEND ON NEXT 25G

      MAXSIZE 10T;

Alter (new 20c)

Autoextend a Persistent Memory Database ALTER PMEM FILESTORE <filestore_name> AUTOEXTEND MOUNTPOINT '<path_and_file_name>' BACKINGFILE '<path_and_backing_file_name>' [REUSE] BLOCK SIZE <2 | 4 | 8 | 16 | 32>K AUTOEXTEND ON NEXT <integer> <K | M | G | T> MAXSIZE <integer> <K | M | G | T>;

ALTER PMEM FILESTORE uw_pmfs
      AUTOEXTEND;

Dismount a Persistent Memory Database ALTER PMEM FILESTORE <filestore_name> DISMOUNT;

ALTER PMEM FILESTORE uw_pmfs
      DISMOUNT;

Mount a Persistent Memory Database ALTER PMEM FILESTORE <filestore_name> MOUNT MOUNTPOINT '<path_and_file_name>' BACKINGFILE '<path_and_file_name>';

ALTER PMEM FILESTORE uw_pmfs
      MOUNT

      MOUNTPOINT '/u03/oracle/pmemfs/perfile2'

      BACKINGFILE '/u04oracle/pmembf/bakfile2'

Resize a Persistent Memory Database ALTER PMEM FILESTORE <filestore_name> RESIZE <integer> <M | G | T>;

ALTER PMEM FILESTORE uw_pmfs
      RESIZE 20T;

Drop (new 20c)

Drop a Persistent Memory Database DROP PMEM FILESTORE <filestore_name> [<EXCLUDING | INCLUDING> CONTENTS] [FORCE];

DROP PMEM FILESTORE uw_pmfs
      INCLUDING CONTENTS FORCE;