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>;
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;