Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

Accessing dynamic performance views

After enabling file mapping, map Oracle datafiles with the DBMS_STORAGE_MAP

package and use SQL commands to display the mapping information captured in

Oracle's dynamic performance views.

To access dynamic performance views

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;

After file mapping has been enabled, Oracle datafiles can be mapped using

the DBMS_STORAGE_MAP package.

For example, this shows how to map a datafile using SQL:

SQL> execute dbms_storage_map.map_file('/oracle/dbs/qio10m.dbf',\

'DATAFILE', TRUE);

For more information about various features and capabilities of the

DBMS_STORAGE_MAP package, see your Oracle documentation.

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 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_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:

Using Storage Mapping

Oracle file mapping (ORAMAP)

146