Veritas Storage Foundation 5.1 SP1: Storage and Availability Management for Oracle (5900-1504, April 2011)

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
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
The following example shows how 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
The following example shows how 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
Recreating Quick I/O files after restoring a database
If you need to restore your database and were using Quick I/O files, you can use
the qio_recreate command to automatically recreate the Quick I/O files after
105Improving database performance with Veritas Quick I/O
Recreating Quick I/O files after restoring a database