Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

For Quick I/O files or raw devices, AUTOEXTEND 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 AUTOEXTEND can grow the
datafile.
You can use AUTOEXTEND with Quick I/O files in the following ways:
■ Preallocate the Quick I/O file to a size at least as big as the maximum growth
size expected for this database file.
Using this method, you would need to preallocate the Quick I/O file emp.dbf
for the entire 300MB. The drawback is that this can unnecessarily lock up
excess disk space. Raw devices have a similar requirement.
■ Monitor the free space available in the Quick I/O file, and grow the file as
necessary with the qiomkfile command.
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 qiomkfile 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.
The following options are available for the qiomkfile command:
Extends the file by a specified amount to allow Oracle tablespace
resizing.
-e
Increases the file to a specified size to allow Oracle tablespace resizing.-r
You can grow underlying VxFS file systems online (provided the underlying disk
or volume can be extended) using the fsadm command. See the fsadm_vxfs(1M)
manual page for more information.
To monitor the free space available in an Oracle tablespace
◆
Check the free space currently available in the Oracle tablespace using the
following Oracle SQL command:
$ sqlplus /nolog
SQL> connect / as sysdba;
SQL> select * from dba_free_space where \
tablespace_name = ’tablespace_name’;
SQL> exit
97Using Veritas Quick I/O
Using Oracle's AUTOEXTEND with Quick I/O files