Veritas Storage Foundation™ for Oracle 5.0.1 Administrator's Guide

■ <mount_point>is the file system's mount point

Extend the Quick I/O file using the qiomkfile command:

$ /opt/VRTS/bin/qiomkfile -e extend_amount /mount_point/filename

$ /opt/VRTS/bin/qiomkfile -r newsize /mount_point/filename

An example to show how to grow VxFS file system /db01 to 500MB and extend

the emp.dbf Quick I/O file by 20MB:

# /opt/VRTS/bin/fsadm -b 500M /db01

$ /opt/VRTS/bin/qiomkfile -e 20M /db01/emp.dbf

An example to show how to grow VxFS file system /db01 to 500MB and resize

the emp.dbf Quick I/O file to 300MB:

# /opt/VRTS/bin/fsadm -b 500M /db01

$ /opt/VRTS/bin/qiomkfile -r 300M /db01/emp.dbf

Using Oracle's AUTOEXTEND with Quick I/O files

Oracle supports an automatic extend feature that automatically grows a database

file by a prespecified amount, up to a prespecified maximum size.

For regular file system files, AUTOEXTEND works transparently, provided the

underlying file system has enough space. For example, suppose the current size

of a database file emp.dbf is 100MB, but this file is expected to triple in size over

time. To accommodate this growth using AUTOEXTEND feature, you can specify the

next size at 20MB and maxsize at 300MB. This will automatically grow the file

by 20MB until its size reaches 300MB. For example:

alter database datafile ’emp.dbf’ autoextend on next 20m\

maxsize 300m;

(See the Oracle Server SQL Reference Guide for more information about the

Note: You must have sufficient space on the underlying file system to AUTOEXTEND

a file, and the underlying storage device must be large enough to contain the new,

larger file system.

Using Veritas Quick I/O

Using Oracle's AUTOEXTEND with Quick I/O files