VERITAS Storage Foundation 4.1 for Oracle RAC HP Serviceguard Storage Management Suite Extracts, December 2005

-------- ---------------------------------------- ------------------------------
Oracle File Mapping (ORAMAP)
Accessing Dynamic Performance Views
1. Confirm the VERITAS mapping library for Oracle file mapping is enabled:
SQL> select lib_idx idx, lib_name name, vendor_name vname, \
path_name path from v$map_library;
IDX NAME VNAME PATH
1 Veritas ORAMAP API Veritas /opt/VRTSormap/lib/libvxoramap.so
2. After enabling storage mapping, map Oracle datafiles using the DBMS_STORAGE_MAP
package.
For more information about features and capabilities of the DBMS_STORAGE_MAP
package, see the Oracle documentation.
3. Use SQL commands to display the mapping information captured in the dynamic
performance views. To display the contents of v$map_file, type:
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, type:
SQL> select * from v$map_file_extent;
To display the contents of v$map_element, type:
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, type:
SQL> select * from v$map_subelement;
To display all the elements within the I/O stack for a specific file, type:
SQL> with fv as
2 (select file_map_idx, file_name from v$map_file
3 where file_name = '/ora92/dbs/qio10m.dbf')
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
160 VERITAS Storage Foundation for Oracle RAC Installation and Configuration Guide