Oracle 12c DBMS_STORAGE

Oracle DBMS_STORAGE_MAP Version 12.1.0.2

General Information

Library Note

Morgan's Library Page Footer

The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,

Purpose

With the DBMS_STORAGE_MAP package, you can communicate with the Oracle background process FMON to invoke mapping operations that populate mapping views. FMON communicates with operating and storage system vendor-supplied mapping libraries.

AUTHID

CURRENT_USER

Dependencies

DBMS_MAP_LIB	MAP_OBJECT	X$KSFMCOMPL
DUAL	MAP_SUBELEMENT$	X$KSFMELEM
MAP_COMPLIST$	V$ARCHIVED_LOG	X$KSFMEXTELEM
MAP_ELEMENT$	V$CONTROLFILE\|	X$KSFMFILE
MAP_EXTELEMENT$	V$DATAFILE	X$KSFMFILEEXT
MAP_FILE$	V$LOGFILE	X$KSFMSUBELEM
MAP_FILE_EXTENT$	V$TEMPFILE

Documented

Yes

File Types

ARCHIVEFILE	DATAFILE	SPFILE
CONTROLFILE	LOGFILE	TEMPFILE

First Available

11.1

Initialization Parameter

set linesize 121
col name format a30
col value format a30

SELECT name, value
FROM gv$parameter
WHERE name LIKE '%f%map%';

ALTER SYSTEM SET file_mapping=TRUE SCOPE=BOTH;

SELECT name, value
FROM gv$parameter
WHERE name LIKE '%f%map%';

ALTER SYSTEM SET file_mapping=FALSE SCOPE=BOTH;

Security Model

Owned by SYS with EXECUTE granted to the DBA role

Source

{ORACLE_HOME}/rdbms/admin/dbmsmap.sql

Subprograms

DROP_ALL	MAP_ALL	RESTORE
DROP_ELEMENT	MAP_ELEMENT	SAVE
DROP_FILE	MAP_FILE	UNLOCK_MAP
LOCK_MAP	MAP_OBJECT

DROP_ALL

Drops all mapping information in the shared memory of the instance

dbms_storage_map.drop_all(dictionary_update IN BOOLEAN DEFAULT TRUE);

exec dbms_storage_map.drop_all(FALSE);

DROP_ELEMENT

Drops the mapping information for the element defined by elemname

dbms_storage_map.drop_element(
elemname IN VARCHAR2,
cascade IN BOOLEAN,
dictionary_update IN BOOLEAN DEFAULT TRUE);

TBD

DROP_FILE

Drops the file mapping information defined by filename

dbms_storage_map.drop_file(
filename IN VARCHAR2,
cascade IN BOOLEAN,
dictionary_update IN BOOLEAN DEFAULT TRUE);

TBD

LOCK_MAP

Locks the mapping information in the shared memory of the instance

dbms_storage_map.lock_map;

exec dbms_storage_map.lock_map;

MAP_ALL

Builds the entire mapping information for all types of Oracle files (except archive logs), including all directed acyclic graph (DAG) elements

dbms_storage_map.map_all(
max_num_fileextent IN NUMBER DEFAULT 100,
dictionary_update IN BOOLEAN DEFAULT TRUE);

TBD

MAP_ELEMENT

Builds mapping information for the element identified by elemname

dbms_storage_map.map_element(
elemname IN VARCHAR2,
cascade IN BOOLEAN,
dictionary_update IN BOOLEAN DEFAULT TRUE);

TBD

MAP_FILE

Builds mapping information for the file identified by filename

dbms_storage_map.map_file(
filename           IN VARCHAR2,
filetype           IN VARCHAR2,
cascade            IN BOOLEAN,
max_num_fileextent IN NUMBER DEFAULT 100,
dictionary_update IN BOOLEAN DEFAULT TRUE);

TBD

MAP_OBJECT

Builds the mapping information for the Oracle object identified by the object name, owner, and type

dbms_storage_map.map_object(
objname IN VARCHAR2,
owner IN VARCHAR2,
objtype IN VARCHAR2);

exec dbms_storage_map.map_object('SERVERS', 'UWCLASS', 'TABLE');

RESTORE

Loads the entire mapping information from the data dictionary into the shared memory of the instance

dbms_storage_map.restore;

exec dbms_storage_map.restore;

SAVE

Saves information needed to regenerate the entire mapping into the data dictionary

dbms_storage_map.save;

exec dbms_storage_map.save;

UNLOCK_MAP

Unlocks the mapping information in the shared memory of the instance

dbms_storage_map.unlock_map;

exec dbms_storage_map.unlock_map;