Veritas Storage Foundation 5.0 for Oracle RAC Configuration Guide Extracts for HP Serviceguard Storage Management Suite, Second Edition, May 2008

Investigating I/O Performance for SG Oracle RAC: Storage Mapping
Oracle File Mapping (ORAMAP)
Chapter 6
131
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
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
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
15 where fv.file_map_idx = fe.file_map_idx)
16 connect by prior sb.child_idx = sb.parent_idx;
Using Oracle Enterprise Manager
Oracle Enterprise Manager is a web-based GUI for managing Oracle databases. You can
use this GUI to perform a variety of administrative tasks such as creating tablespaces,
tables, and indexes; managing user security; and backing up and recovering your
database. You can also use Oracle Enterprise Manager to view performance and status
information about your database instance.