General |
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$MAP_FILE_EXTENT |
v$map_file |
|
V$MAP_ELEMENT |
V$MAP_EXT_ELEMENT |
V$MAP_SUBELEMENT |
V$MAP_COMP_LIST |
V$MAP_LIBRARY |
V$MAP_FILE_IO_STACK |
|
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 role DBA |
|
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; |