CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle DBMS_STORAGE_MAP
Version 11.1
 
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;
 
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [190 users online]    © 2010 psoug.org