| General Information |
| Note: 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. |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsmap.sql |
| First Available |
11.1 |
| Dependencies |
| DBMS_MAP_LIB |
V$CONTROLFILE |
| DUAL |
V$DATAFILE |
| MAP_COMPLIST$ |
V$LOGFILE |
| MAP_ELEMENT$ |
V$TEMPFILE |
| MAP_EXTELEMENT$ |
X$KSFMCOMPL |
| MAP_FILE$ |
X$KSFMELEM |
| MAP_FILE_EXTENT$ |
X$KSFMEXTELEM |
| MAP_OBJECT |
X$KSFMFILE |
| MAP_SUBELEMENT$ |
X$KSFMFILEEXT |
| V$ARCHIVED_LOG |
X$KSFMSUBELEM |
|
| File Types |
| ARCHIVEFILE |
LOGFILE |
| CONTROLFILE |
SPFILE |
| DATAFILE |
TEMPFILE |
|
| 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 |
Execute is granted to the DBA role |
| 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); |
| TBD |
| |
| 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; |
