<!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:31">
<meta name="PRODUCTNAME" content="VERITAS Software Documentation">
<meta name="FILENAME" content="oracle_hp_ch3qio.fm">
     
<title>Using Oracle's AUTOEXTEND With Quick I/O Files</title>

</HEAD>

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

<a name="226492"></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_ch3qio_sf_dbag45_226212.html" title="Previous - Extending a Quick I/O File">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="oracle_hp_ch3qio_sf_dbag47_226804.html" title="Next - Disabling Quick I/O">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="226492"></a>Using Oracle's AUTOEXTEND With Quick I/O Files</font>
</h1>
 
  
  
  

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="226494"></a>Oracle supports an automatic extend feature that automatically grows a database file by a prespecified amount, up to a prespecified maximum size. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="226495"></a>For regular file system files, <font face="Courier New, Courier, sansserif, sans serif" size="2">AUTOEXTEND</font> works transparently, provided the underlying file system has enough space. For example, suppose the current size of a database file <font face="Courier New, Courier, sansserif, sans serif" size="2">emp.dbf</font> is 100MB, but this file is expected to triple in size over time. To accommodate this growth using <font face="Courier New, Courier, sansserif, sans serif" size="2">AUTOEXTEND</font> feature, you can specify the <font face="Courier New, Courier, sansserif, sans serif" size="2">next</font> size at 20MB and <font face="Courier New, Courier, sansserif, sans serif" size="2">maxsize</font> at 300MB. This will automatically grow the file by 20MB until its size reaches 300MB. For example:</font>
</p>

<a name="226496"></a><br><font face="Courier New, Courier, sansserif, sans serif" size="2">	<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>alter database datafile 'emp.dbf' autoextend on next 20m</b></font>\ <br>		<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>maxsize 300m</b></font>;</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="226498"></a>(See the <em>Oracle Server SQL Reference Guide</em> for more information about the <font face="Courier New, Courier, sansserif, sans serif" size="2">alter database</font> command, as well as the <font face="Courier New, Courier, sansserif, sans serif" size="2">next</font> and <font face="Courier New, Courier, sansserif, sans serif" size="2">maxsize</font> parameters.)</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="226499"></a><b>Note  &nbsp;&nbsp;</b>
</font>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2" color="#000000">You must have sufficient space on the underlying file system to <font face="Courier New, Courier, sansserif, sans serif" size="2">AUTOEXTEND</font> a file, and the underlying storage device must be large enough to contain the new, larger file system. 
</font>
<hr noshade size="2" width="100%" color="#000000">
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="226503"></a>For Quick I/O files or raw devices, <font face="Courier New, Courier, sansserif, sans serif" size="2">AUTOEXTEND</font> does not know how to grow the underlying Quick I/O files or devices. Therefore, the Quick I/O file size must be large enough to accommodate the new size before <font face="Courier New, Courier, sansserif, sans serif" size="2">AUTOEXTEND</font> can grow the datafile. </font>
</p>

<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="226514"></a>You can use <font face="Courier New, Courier, sansserif, sans serif" size="2">AUTOEXTEND</font> with Quick I/O files in the following ways: </font>
</p>

<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="226518"></a>Preallocate the Quick I/O file to a size at least as big as the maximum growth size expected for this database file.</font>
</li>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="226522"></a>Using this method, you would need to preallocate the Quick I/O file <font face="Courier New, Courier, sansserif, sans serif" size="2">emp.dbf</font> for the entire 300MB. The drawback is that this can unnecessarily lock up excess disk space. Raw devices have a similar requirement.</font>
</blockquote>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="226526"></a>Monitor the free space available in the Quick I/O file, and grow the file as necessary with the <font face="Courier New, Courier, sansserif, sans serif" size="2">qiomkfile</font> command.</font>
</li>
<blockquote>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="226530"></a>Unlike raw devices, you can easily extend Quick I/O files online. Using this method, you can monitor the free space available in the Oracle datafiles and use the <font face="Courier New, Courier, sansserif, sans serif" size="2">qiomkfile</font> command to grow the Quick I/O files online as and when needed (typically when the file is about 80 to 90 percent full). This method does not require you to lock out unused disk space for Quick I/O files. The free space on the file system is available for use by other applications.</font>
</blockquote>
</ul>
</p>
<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="226539"></a><b>Options</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="226549"></a>For the <font face="Courier New, Courier, sansserif, sans serif" size="2">qiomkfile</font> command:
<Table width="100%" border="0" cellpadding="1" cellspacing="0" >
<tr valign="top"><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="226542"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">-e</font> </font>
</p>

</td><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="226544"></a>Extends the file <em>by</em> a specified amount to allow Oracle tablespace resizing.</font>
</p>

</td></tr><tr valign="top"><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="226546"></a><font face="Courier New, Courier, sansserif, sans serif" size="2">-r</font> </font>
</p>

</td><td><p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="226548"></a>Increases the file <em>to</em> a specified size to allow Oracle tablespace resizing.</font>
</p>

</td></tr>
</Table>


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

<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="226550"></a><b>Usage Notes</b></font>
</p>
<p>
<ul type="disc"><li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="226551"></a>You can grow underlying VxFS file systems online (provided the underlying disk or volume can be extended) using the <font face="Courier New, Courier, sansserif, sans serif" size="2">fsadm</font> command. See the <font face="Courier New, Courier, sansserif, sans serif" size="2">fsadm_vxfs</font>(1M) manual page for more information.</font>
</li>
</ul>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="226552"></a></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="226553"></a>&nbsp;&nbsp;<b>To monitor the free space available in an Oracle tablespace</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="226554"></a>Check the free space currently available in the Oracle tablespace using the following Oracle SQL command:</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="226555"></a>&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2">$</font>&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>sqlplus&nbsp;/nolog</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="226556"></a>&nbsp;SQL&gt;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;connect&nbsp;/&nbsp;as&nbsp;sysdba;</b></font>
</font>
<a name="226557"></a><br><font face="Courier New, Courier, sansserif, sans serif" size="2">	SQL&gt; <font face="Courier New, Courier, sansserif, sans serif" size="2"><b>select * from dba_free_space where </b></font>\<br><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>				 &nbsp;tablespace_name = '</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>tablespace_name</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>';<br></b></font>	SQL&gt; <font face="Courier New, Courier, sansserif, sans serif" size="2"><b>exit</b></font></font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="226558"></a></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="226561"></a>&nbsp;&nbsp;<b>To extend a Quick I/O file using qiomkfile</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="226563"></a>If the datafile is running low on free blocks, use the <font face="Courier New, Courier, sansserif, sans serif" size="2">qiomkfile</font> command to extend the Quick I/O file:</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="226567"></a>&nbsp;$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/qiomkfile&nbsp;-e&nbsp;</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>extend_amount</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;/</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>mount_point</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>filename</b></font>
</font>
<br>
<p>
<font face="Font_SingleByte;" size="2"><a name="226568"></a><b>Example</b></font>
</p>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="226569"></a>To monitor the free space on the tablespace <font face="Courier New, Courier, sansserif, sans serif" size="2">EMP</font> on file system <font face="Courier New, Courier, sansserif, sans serif" size="2">/db01</font>:</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="226570"></a>&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2">$</font>&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>sqlplus&nbsp;/nolog</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="226571"></a>&nbsp;SQL&gt;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;connect&nbsp;/&nbsp;as&nbsp;sysdba;</b></font>
</font>
<a name="226572"></a><br><font face="Courier New, Courier, sansserif, sans serif" size="2">	SQL&gt; <font face="Courier New, Courier, sansserif, sans serif" size="2"><b>select * from dba_free_space where </b></font>\<br><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>				&nbsp;tablespace_name = 'EMP';<br></b></font>	SQL&gt; <font face="Courier New, Courier, sansserif, sans serif" size="2"><b>exit</b></font></font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="226574"></a>To extend the Oracle datafile <font face="Courier New, Courier, sansserif, sans serif" size="2">emp.dbf</font> by 20MB (the specified <font face="Courier New, Courier, sansserif, sans serif" size="2">next</font> size) using the <font face="Courier New, Courier, sansserif, sans serif" size="2">qiomkfile</font> command:</font>
</p>

<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="226576"></a>&nbsp;$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/opt/VRTS/bin/qiomkfile&nbsp;-e&nbsp;20M&nbsp;/db01/emp.dbf</b></font>
</font>

<!-- 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_ch3qio_sf_dbag46_226492.html" title="Using Oracle's AUTOEXTEND With Quick I/O Files">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_ch3qio_sf_dbag45_226212.html" title="Previous - Extending a Quick I/O File">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="oracle_hp_ch3qio_sf_dbag47_226804.html" title="Next - Disabling Quick I/O">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>
