VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Oracle File Mapping (ORAMAP) Prerelease 8 September 2005, 8:55am
150 VERITAS Storage Foundation for Oracle Administrator’s Guide
Note If you want storage mapping to be enabled whenever you start up an instance, set the
file_mapping initialization parameter to true in the init.ora file.
Accessing Dynamic Performance Views
▼ To access dynamic performance views
1. Confirm that the VERITAS mapping library for Oracle file mapping has been enabled.
SQL> select lib_idx idx, lib_name name, vendor_name vname, \
path_name path from v$map_library;
2. After storage mapping has been enabled, Oracle datafiles can be mapped using the
DBMS_STORAGE_MAP package.
The following example shows how to map a datafile using SQL:
For more information about various features and capabilities of the DBMS_STORAGE_MAP
package, see your Oracle documentation.
3. Use SQL commands to display the mapping information that is captured in Oracle’s dynamic
performance views.
To display the contents of v$map_file for a Quick I/O file:
SQL> select file_name name, file_map_idx idx, \
file_status status, file_type type, file_structure str, \
file_size fsize, file_nexts nexts from v$map_file;
To display the contents of v$map_file_extent.
SQL> select * from v$map_file_extent;
To display the contents of v$map_element:
SQL> select elem_idx idx, elem_name, elem_type type, elem_size, \
elem_nsubelem nsub, elem_descr, stripe_size from \
v$map_element;
To display the contents of v$map_subelement:
SQL> select * from v$map_subelement
▼ To display all the elements within the I/O stack for a specific file.
SQL> with fv as
2 (select file_map_idx, file_name from v$map_file
4 select