Oracle DBMS_STORAGE_MAP
Version 19.2.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
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
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;

Related Topics
Built-in Functions
Built-in Packages
FMON Process
What's New In 18cR3
What's New In 19cR2

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