<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Transitional//EN">
<HTML>
<HEAD>
  <!--
    *************************************************************************************
    * Copyright (c) 2005 VERITAS Software Corporation. All rights reserved. *

      For third-party license citations, please see the bottom of this file.
    *************************************************************************************
  -->
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="TEMPLATEBASE" content="vx_vxhelp_2005c">
<meta name="LASTUPDATED" content="06/13/05 10:35:36">
<meta name="PRODUCTNAME" content="VERITAS Software Documentation">
<meta name="FILENAME" content="oracle_hp_ch6filemap.fm">
     
<title>Oracle File Mapping (ORAMAP)</title>

</HEAD>

<BODY bgcolor="#FFFFFF" link="#000066" vlink="#0000ff" marginheight="0" topmargin="0">
<basefont=1>

<a name="212320"></a>

<div align="left">
<table border="0" cellspacing="0" cellpadding="0" width="100%">
 <tr>
   <td height="2" border="0" cellspacing="0" cellpadding="0" colspan="2" bgcolor="#000000">
   </td>
 </tr>
 <tr>
   <td height="15" width="50%" border="0" cellspacing="0" cellpadding="0" bgcolor="#cccccc">
    <img src="images/vxsymbol.gif" height="20" width="31" border="0" cellspacing="0" cellpadding="0" align="left">
     
     
   </td>
   <td align="right" width="50%" bgcolor="#cccccc">

<!-- Header Breadcrumbs -->
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="-2">&lt;&nbsp;<a href="oracle_hp_ch6filemap_sf_dbag67_212077.html" title="Previous - Viewing Storage Mapping Topology and I/O Statistics Using the GUI">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="oracle_hp_ch6filemap_sf_dbag69_213070.html" title="Next - Configuring Arrays for Storage Mapping and Statistics">Next</a>
&nbsp;&gt;&nbsp;&nbsp;</font>
   </td>
 </tr>

 <tr>
  <td bgcolor="#CCCCCC" colspan="2" height="15" align="right">
  <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">Product:  
<a href="sf_dbag_splashpage_docCD_sf_dbag1_103036.vxhd" title="Storage Foundation for Databases Guides title page ">Storage Foundation for Databases Guides</a>
  &nbsp;&nbsp;
  </font>
  </td>
 </tr>
 <tr>
  <td bgcolor="#CCCCCC" colspan="2" height="15" align="right">
  <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">Manual:  
<a href="oracle_hp_dbag_titlepage_docCD_sf_dbag2_73700.vxhd" title="Storage Foundation 4.1 for Oracle Administrator's Guide title page ">Storage Foundation 4.1 for Oracle Administrator's Guide</a>
  &nbsp;&nbsp;
  </font>
  </td>
 </tr>


</table>
</div>

<div align="left">
 <table border="0" width="100%" bgcolor="#FFFFFF">
  <tr>
   <td width="100%" valign="top" bgcolor="#FFFFFF">

<!-- Start Main Topic Content -->
        <a name="startcontent"></a>
	
<h1><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="+1" color="#000000"><a name="212320"></a>Oracle File Mapping (ORAMAP)</font>
</h1>
 
  
  
  

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212321"></a>VERITAS has defined and implemented two libraries: <font face="Courier New, Courier, sansserif, sans serif" size="2">libvxoramap_64.so</font> for HPUX PA and <font face="Courier New, Courier, sansserif, sans serif" size="2">libvxoramap_64.sl</font> for HPUX IA architecture. These two libraries provide a mapping interface to Oracle9<em>i</em> release 2 or later. <font face="Courier New, Courier, sansserif, sans serif" size="2">libvxoramap_64.so</font> serves as a bridge between Oracle's set of storage APIs (known as &quot;ORAMAP&quot;) and VERITAS Federated 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.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212324"></a>With VERITAS Storage Foundation <em>for Oracle</em> Storage Mapping option, you can view the complete I/O topology mapping of datafiles through intermediate layers like logical volumes down to actual physical devices. This information can be used to determine the exact location of an Oracle data block on a physical device and to help identify hot spots.</font>
</p>

<hr noshade size="2" width="100%" color="#000000">
<img src="images/note.gif" alt="Note " height="16" width="16">&nbsp;
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="212326"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">To use the mapping functionality, you must be using Oracle 9.2.0.3 or later.
</font>
<hr noshade size="2" width="100%" color="#000000">



<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="212329"></a>Mapping Components</font>
</h2>
 
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212330"></a>The mapping components in the System Global Area (SGA) and Oracle's representation of these components are described in this section. You will need an understanding of these components to interpret the mapping information in Oracle's dynamic performance views.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212331"></a>The mapping information in Oracle's dynamic performance views consists of:</font>
</p>

<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212332"></a>File components</font>
</li>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212333"></a>A mapping file component is a mapping structure describing a file. It provides a set of attributes for a file, including the file's size, number of extents, and type. File components are exported to the user through <font face="Courier New, Courier, sansserif, sans serif" size="2">V$MAP_FILE</font>.</font>
</blockquote>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212334"></a>File extent components</font>
</li>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212335"></a>A mapping file extent component describes a contiguous group of blocks residing on one element. The description specifies the device offset, the extent size, the file offset, the extent type (<font face="Courier New, Courier, sansserif, sans serif" size="2">Data</font> or <font face="Courier New, Courier, sansserif, sans serif" size="2">Parity</font>), and the name of the element where the extent resides. </font>
</blockquote>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212336"></a>Element components</font>
</li>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212337"></a>A mapping element component is a mapping structure that describes a storage component within the I/O stack. Elements can be mirrors, stripes, partitions, RAID5, concatenated elements, and disks. </font>
</blockquote>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212338"></a>This component contains information about the element's mapping structure, such as the element's size, type, number of subelements, and a brief description. Element components are exported to the user through <font face="Courier New, Courier, sansserif, sans serif" size="2">V$MAP_ELEMENT</font>.</font>
</blockquote>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212339"></a>Subelement components</font>
</li>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212340"></a>A mapping subelement component describes the link between an element and the next element in the I/O stack. The subelement component contains the subelement number, size, the element name for the subelement, and the element offset. Subelement components are exported to the user through <font face="Courier New, Courier, sansserif, sans serif" size="2">V$MAP_SUBELEMENT</font>.</font>
</blockquote>
</ul>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212341"></a>These four types of mapping components completely describe the mapping information for an Oracle instance.</font>
</p>




<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="212344"></a>Storage Mapping Views</font>
</h2>
 
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212345"></a>The mapping information that is captured is presented in Oracle's dynamic performance views. Brief descriptions of these views are provided below. For more detailed information, refer to your Oracle documentation.
<Table width="100%" border="1" cellpadding="2" cellspacing="0" >
<tr bgcolor="#CCCCCC"><th align="left"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000"><b><a name="212348"></a>View</b>
</font></th>

<th align="left"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000"><b><a name="212350"></a>Description</b>
</font></th>

</tr>
<tr valign="top"><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212352"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">V$MAP_LIBRARY</font></font>
</p>
</td>
<td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212354"></a>Contains a list of all the mapping libraries that have been dynamically loaded by the external process.</font>
</p>
</td>
</tr>
<tr valign="top"><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212356"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">V$MAP_FILE</font></font>
</p>
</td>
<td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212358"></a>Contains a list of all the file mapping structures in the shared memory of the instance.</font>
</p>
</td>
</tr>
<tr valign="top"><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212360"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">V$MAP_FILE_EXTENT</font></font>
</p>
</td>
<td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212362"></a>Contains a list of all the file extent mapping structures in the shared memory of the instance.</font>
</p>
</td>
</tr>
<tr valign="top"><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212364"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">V$MAP_ELEMENT</font></font>
</p>
</td>
<td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212366"></a>Contains a list of all the element mapping structures in the SGA of the instance.</font>
</p>
</td>
</tr>
<tr valign="top"><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212368"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">V$MAP_EXT_ELEMENT</font></font>
</p>
</td>
<td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212370"></a>Contains supplementary information for all element mapping structures.</font>
</p>
</td>
</tr>
<tr valign="top"><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212372"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">V$MAP_SUBELEMENT</font></font>
</p>
</td>
<td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212374"></a>Contains a list of all subelement mapping structures in the shared memory of the instance.</font>
</p>
</td>
</tr>
<tr valign="top"><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212376"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">V$MAP_COMP_LIST</font></font>
</p>
</td>
<td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212378"></a>Describes the component list associated with the element name.</font>
</p>
</td>
</tr>
<tr valign="top"><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212380"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">V$MAP_FILE_IO_STACK</font></font>
</p>
</td>
<td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212382"></a>Contains the hierarchical arrangement of storage containers for the file. This information is displayed as a series of rows. Each row represents a level in the hierarchy.</font>
</p>
</td>
</tr>

</table>


<Table width="100%" border="0" cellpadding="1" cellspacing="0">
<tr><td>
</Table></font>
</p>




<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="212384"></a>Verifying Oracle File Mapping Setup</font>
</h2>
 
</ol>
<p><img src="images/stepintro.gif" height="16" width="16">
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="212385"></a>&nbsp;&nbsp;<b>To verify that $ORACLE_HOME is set up for Oracle file mapping (ORAMAP)</b></font>
</p>
<ol>
<li value="1">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212386"></a>Enter:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212387"></a>#&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>cd&nbsp;$ORACLE_HOME/rdbms/filemap/bin</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212388"></a>#&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>ls&nbsp;&#8211;l</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212389"></a>-r-xr-x---&nbsp;1&nbsp;root&nbsp;system&nbsp;900616&nbsp;Apr&nbsp;08&nbsp;19:16&nbsp;fmputl
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212390"></a>-r-sr-xr-x&nbsp;1&nbsp;root&nbsp;system&nbsp;14614&nbsp;Apr&nbsp;08&nbsp;19:16&nbsp;fmputlhp
</font>
<li value="2">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212391"></a>Verify that:
</font>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212392"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">fmputlhp</font> is owned by <font face="Courier New, Courier, sansserif, sans serif" size="2">root</font> and that the <font face="Courier New, Courier, sansserif, sans serif" size="2">setud</font> bit is set.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212393"></a>The permissions for <font face="Courier New, Courier, sansserif, sans serif" size="2">fmputlhp</font> are set to <font face="Courier New, Courier, sansserif, sans serif" size="2">-r-sr-xr-x</font>.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212394"></a>The permissions for <font face="Courier New, Courier, sansserif, sans serif" size="2">fmputl</font> are set to <font face="Courier New, Courier, sansserif, sans serif" size="2">-r-xr-x---.</font></font>
</li>
</ul>
</p>
<li value="3">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212395"></a>If any of these items is not set as specified, make the appropriate corrections.
</font>
</ol>



<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="212397"></a>Enabling Oracle File Mapping</font>
</h2>
 
</ol>
<p><img src="images/stepintro.gif" height="16" width="16">
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="212398"></a>&nbsp;&nbsp;<b>To enable Oracle file mapping with the VERITAS Storage Mapping option</b></font>
</p>
<ol>
<li value="1">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212399"></a>Ensure that the file <font face="Courier New, Courier, sansserif, sans serif" size="2">filemap.ora</font> exists and contains a valid entry for the VERITAS mapping library for Oracle storage mapping.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212400"></a>&nbsp;&nbsp;#&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>cd&nbsp;$ORACLE_HOME/rdbms/filemap/etc</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212401"></a>&nbsp;&nbsp;#&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>cat&nbsp;filemap.ora</b></font>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212404"></a>For 64-bit Oracle, the <font face="Courier New, Courier, sansserif, sans serif" size="2">filemap.ora</font> file should contain the following setting:</font>
</p>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212405"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;&nbsp;lib=VERITAS:/opt/VRTSdbed/lib/libvxoramap_64.so</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212406"></a>&nbsp;&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>lib=VERITAS:/opt/VRTSdbed/lib/libvxoramap_64.so&nbsp;for&nbsp;PA</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212407"></a>&nbsp;&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>lib=VERITAS:/opt/VRTSdbed/lib/libvxoramap_64.sl&nbsp;for&nbsp;IA</b></font>
</font>
<li value="2">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212408"></a>After verifying that the system is using the VERITAS library for Oracle storage mapping, set the <font face="Courier New, Courier, sansserif, sans serif" size="2">file_mapping</font> initialization parameter to <font face="Courier New, Courier, sansserif, sans serif" size="2">true</font>.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212409"></a>SQL&gt;&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>alter&nbsp;system&nbsp;set&nbsp;file_mapping=true;</b></font>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212410"></a>The <font face="Courier New, Courier, sansserif, sans serif" size="2">file_mapping</font> initialization parameter is set to <font face="Courier New, Courier, sansserif, sans serif" size="2">false</font> by default. You do not need to shut down the instance to set this parameter. Setting <font face="Courier New, Courier, sansserif, sans serif" size="2">file_mapping=true</font> starts the <font face="Courier New, Courier, sansserif, sans serif" size="2">FMON</font> background process.</font>
</p>
<hr noshade size="2" width="100%" color="#000000">
<img src="images/note.gif" alt="Note " height="16" width="16">&nbsp;
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="212411"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">If you want storage mapping to be enabled whenever you start up an instance, set the <font face="Courier New, Courier, sansserif, sans serif" size="2">file_mapping</font> initialization parameter to <font face="Courier New, Courier, sansserif, sans serif" size="2">true</font> in the <font face="Courier New, Courier, sansserif, sans serif" size="2">init.ora</font> file. 
</font>
<hr noshade size="2" width="100%" color="#000000">
</ol>



<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="212413"></a>Accessing Dynamic Performance Views</font>
</h2>
 
</ol>
<p><img src="images/stepintro.gif" height="16" width="16">
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="212414"></a>&nbsp;&nbsp;<b>To access dynamic performance views</b></font>
</p>
<ol>
<li value="1">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212415"></a>Confirm that the VERITAS mapping library for Oracle file mapping has been enabled.
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212422"></a>&nbsp;&nbsp;SQL&gt;&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>select&nbsp;lib_idx&nbsp;idx,&nbsp;lib_name&nbsp;name,&nbsp;vendor_name&nbsp;vname,</b></font>&nbsp;\
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212423"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;path_name&nbsp;path&nbsp;from&nbsp;v$map_library;</b></font>
</font>
<li value="2">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212431"></a>After storage mapping has been enabled, Oracle datafiles can be mapped using the <font face="Courier New, Courier, sansserif, sans serif" size="2">DBMS_STORAGE_MAP</font> package. 
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212432"></a>The following example shows how to map a datafile using SQL:</font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212435"></a>For more information about various features and capabilities of the <font face="Courier New, Courier, sansserif, sans serif" size="2">DBMS_STORAGE_MAP</font> package, see your Oracle documentation.</font>
</p>
<li value="3">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212436"></a>Use SQL commands to display the mapping information that is captured in Oracle's dynamic performance views. 
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212437"></a>To display the contents of <font face="Courier New, Courier, sansserif, sans serif" size="2">v$map_file</font> for a Quick I/O file:</font>
</p>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212443"></a>&nbsp;&nbsp;SQL&gt;&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>select&nbsp;file_name&nbsp;name,&nbsp;file_map_idx&nbsp;idx,&nbsp;</b></font>\
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212444"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;file_status&nbsp;status,</b></font>&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>file_type&nbsp;type,&nbsp;file_structure&nbsp;str,&nbsp;</b></font>\
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212445"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;file_size&nbsp;fsize,&nbsp;file_nexts&nbsp;nexts&nbsp;from&nbsp;v$map_file;</b></font>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212454"></a>To display the contents of <font face="Courier New, Courier, sansserif, sans serif" size="2">v$map_file_extent</font>.</font>
</p>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212455"></a>&nbsp;&nbsp;SQL&gt;&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>select&nbsp;*&nbsp;from&nbsp;v$map_file_extent;</b></font>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212465"></a>To display the contents of <font face="Courier New, Courier, sansserif, sans serif" size="2">v$map_element</font>:</font>
</p>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212471"></a>&nbsp;&nbsp;SQL&gt;&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>select&nbsp;elem_idx&nbsp;idx,&nbsp;elem_name,&nbsp;elem_type&nbsp;type,&nbsp;elem_size,</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2">&nbsp;\</font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212472"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;elem_nsubelem&nbsp;nsub,&nbsp;elem_descr,&nbsp;stripe_size&nbsp;from</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2">&nbsp;\</font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212473"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;v$map_element;</b></font>
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212497"></a>To display the contents of<font face="Courier New, Courier, sansserif, sans serif" size="2">&nbsp;v$map_subelement</font>:</font>
</p>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212498"></a>&nbsp;&nbsp;SQL&gt;&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>select&nbsp;*&nbsp;from&nbsp;v$map_subelement</b></font>
</font>
</ol>
</ol>
<p><img src="images/stepintro.gif" height="16" width="16">
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="212524"></a>&nbsp;&nbsp;<b>To display all the elements within the I/O stack for a specific file.</b></font>
</p>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212529"></a>&nbsp;&nbsp;SQL&gt;&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>with&nbsp;fv&nbsp;as</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212530"></a>&nbsp;&nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>(select&nbsp;file_map_idx,&nbsp;file_name&nbsp;from&nbsp;v$map_file</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212533"></a>&nbsp;&nbsp;&nbsp;4&nbsp;&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>select</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212534"></a>&nbsp;&nbsp;&nbsp;5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>fv.file_name,&nbsp;lpad('&nbsp;',&nbsp;4&nbsp;*&nbsp;(level&nbsp;-&nbsp;1))&nbsp;||</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2">&nbsp;\&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212535"></a><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;el.elem_name&nbsp;</b></font>elem_name,&nbsp;el.elem_size,&nbsp;el.elem_type,<font face="Courier New, Courier, sansserif, sans serif" size="2">&nbsp;\</font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212536"></a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>el.elem_descr</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212537"></a>&nbsp;&nbsp;&nbsp;6&nbsp;&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>from</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212538"></a>&nbsp;&nbsp;&nbsp;7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>v$map_subelement&nbsp;sb,&nbsp;v$map_element&nbsp;el,&nbsp;fv,</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212539"></a>&nbsp;&nbsp;&nbsp;8&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>(select&nbsp;unique&nbsp;elem_idx&nbsp;from&nbsp;v$map_file_io_stack&nbsp;io,&nbsp;fv</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212540"></a>&nbsp;&nbsp;&nbsp;9&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>where&nbsp;io.file_map_idx&nbsp;=&nbsp;fv.file_map_idx)&nbsp;fs</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212541"></a>&nbsp;&nbsp;&nbsp;10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>where&nbsp;el.elem_idx&nbsp;=&nbsp;sb.child_idx</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212542"></a>&nbsp;&nbsp;&nbsp;11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>and&nbsp;fs.elem_idx&nbsp;=&nbsp;el.elem_idx</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212543"></a>&nbsp;&nbsp;&nbsp;12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>start&nbsp;with&nbsp;sb.parent_idx&nbsp;in</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212544"></a>&nbsp;&nbsp;&nbsp;13&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>(select&nbsp;distinct&nbsp;elem_idx</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212545"></a>&nbsp;&nbsp;&nbsp;14&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>from&nbsp;v$map_file_extent&nbsp;fe,&nbsp;fv</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212546"></a>&nbsp;&nbsp;&nbsp;15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>where&nbsp;fv.file_map_idx&nbsp;=&nbsp;fe.file_map_idx)</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="212547"></a>&nbsp;&nbsp;&nbsp;16&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>connect&nbsp;by&nbsp;prior&nbsp;sb.child_idx&nbsp;=&nbsp;sb.parent_idx;</b></font>
</font>



<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="212568"></a>Using Oracle Enterprise Manager</font>
</h2>
 
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212569"></a>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.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212570"></a>From Oracle Enterprise Manager, you can view storage mapping information and a graphical display of the storage layout. Storage mapping information cannot be viewed with the Oracle 10g version of the Oracle Enterprise Manager client. However, the Oracle9i version of Oracle Enterprise Manager can be used with Oracle 10g to view storage mapping information.</font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212571"></a>For more information about Oracle Enterprise Manager, refer to your Oracle documentation.</font>
</p>

</ol>
<p><img src="images/stepintro.gif" height="16" width="16">
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000"><a name="212572"></a>&nbsp;&nbsp;<b>To view storage information</b></font>
</p>
<ol>
<li value="1">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212573"></a>To view storage information, start Oracle Enterprise Manager and select a database from the left navigational pane (the object tree) of the Oracle Enterprise Manager Console.
</font>
<li value="2">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212574"></a>Expand the Databases icon and select the desired database.
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212575"></a>The Database Connect Information window appears.</font>
</p>
<li value="3">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212576"></a>Enter a user name and password to log in to the database and click <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>OK</b></font>.
</font>
<li value="4">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212577"></a>In the object tree, expand the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Storage</b></font> icon.
</font>
<li value="5">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212578"></a>Under the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Storage</b></font> icon, expand the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Datafiles</b></font> icon. 
</font>
<li value="6">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212579"></a>Select the datafile for which you want to view storage layout information.
</font>
<li value="7">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212580"></a>In the right pane, click the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Storage Layout</b></font> tab.
</font>
<li value="8">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212581"></a>Expand the objects to display their storage layout.
</font>
<hr noshade size="2" width="100%" color="#000000">
<img src="images/note.gif" alt="Note " height="16" width="16">&nbsp;
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="212582"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">Within the Oracle Enterprise Manager Console, you can point to an object on the screen and a description of the object is displayed in a pop-up field. If an object name or path appears truncated, point to it and the pop-up field will display the full object name and path. 
</font>
<hr noshade size="2" width="100%" color="#000000">
<hr noshade size="2" width="100%" color="#000000">
<img src="images/note.gif" alt="Note " height="16" width="16">&nbsp;
<font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="2" color="#000000">
<a name="212583"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">You can also right click on an object and select <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>View Details</b></font> to see detailed information about the object.
</font>
<hr noshade size="2" width="100%" color="#000000">
<a name="no_figure_caption0"> </a>

<a name="no_figure_caption1"> </a>

<li value="9">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212641"></a>By default, storage layout information is displayed in a tabular format. That is, the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Tabular Display</b></font> icon is selected. To view a graphical display of the storage layout, click the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Graphical Display</b></font> icon.
</font>
<a name="no_figure_caption2"> </a>

<a name="no_figure_caption3"> </a>

<li value="10">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212666"></a>Expand the objects to display their storage layout information graphically.
</font>
<li value="11">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212667"></a>To exit, choose <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>Exit</b></font> from the <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><b>File</b></font> menu.
</font>
</ol>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="212668"></a></font>
</p>


<!-- End Main Topic Content -->

   </td>
  </tr>
 </table>
</div>

<div>
<table border="0" cellspacing="0" cellpadding="0" width="100%">
 <tr>
  <td height="18" border="0" cellspacing="0" cellpadding="0" colspan="2" bgcolor="#FFFFFF">
  </td>
 </tr>
  <td align="left"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="-2">&nbsp;&#94;&nbsp;<a href="oracle_hp_ch6filemap_sf_dbag68_212320.html" title="Oracle File Mapping (ORAMAP)">Return to Top</a></font>

  </td>
  <td align="right"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="-2">&lt;&nbsp;<a href="oracle_hp_ch6filemap_sf_dbag67_212077.html" title="Previous - Viewing Storage Mapping Topology and I/O Statistics Using the GUI">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="oracle_hp_ch6filemap_sf_dbag69_213070.html" title="Next - Configuring Arrays for Storage Mapping and Statistics">Next</a>
&nbsp;&gt;&nbsp;&nbsp;</font>
  </td>
 <tr>
   <td height="9" border="0" cellspacing="0" cellpadding="0" colspan="2" bgcolor="#FFFFFF">
   </td>
 </tr>

<!-- Footer Breadcrumbs -->
<tr>
<td bgcolor="#FFFFFF" colspan="2" height="15" align="right">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">Product:  
<a href="sf_dbag_splashpage_docCD_sf_dbag1_103036.vxhd" title="Storage Foundation for Databases Guides title page ">Storage Foundation for Databases Guides</a>&nbsp;&nbsp;</font></td>
</tr>

<tr>
<td bgcolor="#FFFFFF" colspan="2" height="15" align="right">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">Manual:  
<a href="oracle_hp_dbag_titlepage_docCD_sf_dbag2_73700.vxhd" title="Storage Foundation 4.1 for Oracle Administrator's Guide title page ">Storage Foundation 4.1 for Oracle Administrator's Guide</a>&nbsp;&nbsp;</font></td>
</tr>


 <tr>
  <td colspan="2" align="left"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" color="#000000" align="right" size="-2">
<em>VERITAS Software Corporation
</em></font><br>

<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="-2">www.veritas.com</font><br>
  </td>
 </tr>
</table>
</div>

</BODY>
  <!--
    *************************************************************************************
    * Copyright (c) 2005 VERITAS Software Corporation. All rights reserved. *

    VERITAS, VERITAS SOFTWARE, the VERITAS Logo, and VERITAS Software Documentation 
    are trademarks or registered trademarks of VERITAS Software Corporation 
    or its affiliates in the U.S. and other countries. Other names may be 
    trademarks of their respective owners. 

    Apache Jakarta Lucene:
    Apache Software License
    Version 1.1

    Copyright (c) 2000 The Apache Software Foundation. All rights reserved.

    Redistribution and use in source and binary forms, with or without modification, 
    are permitted provided that the following conditions are met:

    1. Redistributions of source code must retain the above copyright notice, this 
    list of conditions and the following disclaimer.

    2. Redistributions in binary form must reproduce the above copyright notice, this 
    list of conditions and the following disclaimer in the documentation and/or other 
    materials provided with the distribution.

    3. The end-user documentation included with the redistribution, if any, must include 
    the following acknowledgment: "This product includes software developed by the Apache 
    Software Foundation (http://www.apache.org/)." Alternately, this acknowledgment may 
    appear in the software itself, if and wherever such third-party acknowledgments 
    normally appear.

    4. The names "Apache" and "Apache Software Foundation" must not be used to endorse or 
    promote products derived from this software without prior written permission. For 
    written permission, please contact apache@apache.org.

    5. Products derived from this software may not be called "Apache", nor may "Apache" 
    appear in their name, without prior written permission of the Apache Software Foundation.

    THIS SOFTWARE IS PROVIDED "AS IS" AND ANY EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, 
    BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A 
    PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION 
    OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, 
    OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS 
    OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND 
    ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING 
    NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF 
    ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

    This software consists of voluntary contributions made by many individuals on behalf 
    of the Apache Software Foundation. For more information on the Apache Software Foundation, 
    please see <http://www.apache.org/>. Portions of this software are based upon public domain 
    software originally written at the National Center for Supercomputing Applications, University 
    of Illinois, Urbana-Champaign.
    
    This product includes WebWindow Software developed by Horst Heistermann.
    *************************************************************************************
  -->
</HTML>
