Storage mapping enables you to map datafiles to physical devices. You may obtain and view detailed storage topology information using the vxstorage_stats
and dbed_analyzer
commands. You may also use the Oracle Enterprise Manager to access storage mapping information.
Access to mapping information is important since it allows for a detailed understanding of the storage hierarchy in which files reside, information that is critical for effectively evaluating I/O performance.
Mapping files to their underlying device is straightforward when datafiles are created directly on a raw device. With the introduction of host-based volume managers and sophisticated storage subsystems that provide RAID features, however, mapping files to physical devices has become more difficult.
With the VERITAS Storage Foundation for Oracle storage mapping option, you can map datafiles to physical devices. Storage mapping relies on Veritas Mapping Service (VxMS), a library that assists in the development of distributed SAN applications that must share information about the physical location of files and volumes on a disk.
The storage mapping option supports Oracle's set of storage APIs called Oracle Mapping ("ORAMAP" for short) that lets Oracle determine the mapping information for files and devices.
Oracle provides a set of dynamic performance views (V$
views) that shows the complete mapping of a file to intermediate layers of logical volumes and physical devices. These views enable you to locate the exact disk on which any specific block of a file resides. You can use these mappings, along with device statistics, to evaluate I/O performance.
The VERITAS Storage Foundation for Oracle storage mapping option supports a wide range of storage devices and allows for "deep mapping" into EMC, Hitachi, and IBM Enterprise Storage Server ("Shark") arrays. Deep mapping information identifies the physical disks that comprise each LUN and the hardware RAID information for the LUNs.
You can view storage mapping topology information and I/O statistics using:
vxstorage_stats
command. This command displays the complete I/O topology mapping of specific datafiles through intermediate layers like logical volumes down to actual physical devices.
dbed_analyzer
command. This command retrieves tablespace-to-physical disk mapping information for all the datafiles in a specified database. It also provides information about the amount of disk space being used by a tablespace.
In addition, you can also use the Oracle Enterprise Manager GUI to display storage mapping information after file mapping has occurred. Oracle Enterprise Manager does not display I/O statistics information. Unlike the information displayed using the Veritas command line, the information displayed in Oracle Enterprise Manager may be "stale," that is, it may not be the latest information.
For information on the command line options or the Oracle Enterprise Manager, see the chapter on using storage mapping in the Veritas Storage Foundation for Oracle Administrator's Guide.
Note For Solaris users, if you use Veritas FlashSnap Agent for Symmetrix, you cannot use the mapping functionality for non-Symmetrix arrays.