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

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;

Related Topics
Database Security
Built-in Functions
Built-in Packages
PMEM_FILESTORE Parameter
What's New In 19c
What's New In 20c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx