Veritas Storage Foundation™ 5.0.1 for Oracle RAC Installation, Configuration, and Administrator's Guide Extracts for the HP Serviceguard Storage Management Suite on HP-UX 11i v3

lib=VERITAS:/opt/VRTSdbed/lib/libvxoramap_64.sl
2. After verifying that the system is using the Veritas library for Oracle storage mapping, set
the file_mapping initialization parameter to true.
SQL> alter system set file_mapping=true;
The file_mapping initialization parameter is set to false by default. You do not
need to shut down the instance to set this parameter. Setting file_mapping=true starts
the FMON background process.
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.
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
5 fv.file_name, lpad(' ', 4 * (level - 1)) || \
el.elem_name elem_name, el.elem_size, el.elem_type, \
el.elem_descr
6 from
7 v$map_subelement sb, v$map_element el, fv,
8 (select unique elem_idx from v$map_file_io_stack io, fv
9 where io.file_map_idx = fv.file_map_idx) fs
10 where el.elem_idx = sb.child_idx
11 and fs.elem_idx = el.elem_idx
12 start with sb.parent_idx in
13 (select distinct elem_idx
14 from v$map_file_extent fe, fv
92 Investigating I/O Performance for SGeRAC: Storage Mapping