< Previous  | TOC | Index | Next  >

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

     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;