Oracle DBMS_STORAGE_MAP
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.0.1. 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.
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
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);
 
 
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;

Related Topics
FMON Process
Packages

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-2014 Daniel A. Morgan All Rights Reserved