Oracle | Persistent Memory Database

Oracle Persistent Memory Database Version 20c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Be sure to view the full listing of monographs in Morgan's Library

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;