VERITAS Storage Foundation 4.1 Oracle Administrator's Guide

Using Oracle’s AUTOEXTEND With Quick I/O Files Prerelease 8 September 2005, 8:54am
106 VERITAS Storage Foundation for Oracle Administrator’s Guide
Usage Notes
◆ 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
▼ To extend a Quick I/O file using qiomkfile
If the datafile is running low on free blocks, use the qiomkfile command to extend the Quick
I/O file:
$ /opt/VRTS/bin/qiomkfile -e extend_amount /mount_point/filename
Example
To monitor the free space on the tablespace EMP on file system /db01:
$ sqlplus /nolog
SQL> connect / as sysdba;
SQL> select * from dba_free_space where \
tablespace_name = ’EMP’;
SQL> exit
To extend the Oracle datafile emp.dbf by 20MB (the specified next size) using the
qiomkfile command:
$ /opt/VRTS/bin/qiomkfile -e 20M /db01/emp.dbf
-r Increases the file to a specified size to allow Oracle tablespace resizing.