Oracle DBMS_STORAGE_MAP
Version 21c

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.
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  
Supported File Types
ARCHIVEFILE DATAFILE SPFILE
CONTROLFILE LOGFILE TEMPFILE
Documented Yes
Exceptions
Error Code Reason
ORA-32051 mapping service not available
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);
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;

PL/SQL procedure successfully completed.

Related Topics
Built-in Functions
Built-in Packages
FMON Process
What's New In 19c
What's New In 20c-21c

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