Oracle | DBMS_STORAGE

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	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;

      

      PL/SQL procedure successfully completed.