Veritas Storage Foundation for Oracle 5.0 Administrator's Guide, HP-UX 11i v3, Second Edition, December 2008

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 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.

Using Storage Mapping

Oracle file mapping (ORAMAP)

148