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

-rw-r--r-- 1 oracle dba 104890368 Oct 2 13:42 .dbfile

lrwxrwxrwx 1 oracle dba 19 Oct 2 13:42 dbfile -> \

.dbfile::cdev:vxfs:

In the example, qiomkfile creates a regular file named /db01/.dbfile, which

has the real space allocated. Then, qiomkfile creates a symbolic link named

/db01/dbfile. This symbolic link is a relative link to the Quick I/O interface for

/db01/.dbfile, that is, to the .dbfile::cdev:vxfs: file. The symbolic link allows

.dbfile to be accessed by any database or application using its Quick I/O

interface.

Preallocating space for Quick I/O files using the setext

command

As an alternative to using the qiomkfile command, you can also use the VxFS

setext command to preallocate space for database files.

Before preallocating space with setext, make sure the following conditions have

been met:

■ The setext command requires superuser (root) privileges.Prerequisites

■ You can use the chown command to change the owner and group

permissions on the file after you create it.

See the setext (1M) manual page for more information.

Usage notes

To create a Quick I/O database file using setext

Access the VxFS mount point and create a file:

# cd /mount_point

# touch .filename

Use the setext command to preallocate space for the file:

# /opt/VRTS/bin/setext -r size -f noreserve -f chgsize \

.filename

Improving database performance with Veritas Quick I/O

Preallocating space for Quick I/O files using the setext command