Oracle 12cR2 DBMS_STORAGE

Oracle DBMS_STORAGE_MAP Version 12.2.0.1

General Information

Library Note

Morgan's Library Page Header

Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't make it this year, check out TidalScale at www.tidalscale.com. Be sure to click on the Solutions link and look through the Oracle resources.

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;