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

Creating database files as Quick I/O files using

qiomkfile

The best way to preallocate space for tablespace containers and to make them

accessible using the Quick I/O interface is to use the qiomkfile. You can use the

qiomkfile to create the Quick I/O files for either temporary or permanent

tablespaces.

■ You can create Quick I/O files only on VxFS file systems.

■ If you are creating database files on an existing file system, run

fsadm (or similar utility) to report and eliminate fragmentation.

■ You must have read/write permissions on the directory in which

you intend to create Oracle Quick I/O files.

Prerequisites

■ The qiomkfile command creates two files: a regular file with

preallocated, contiguous space, and a file that is a symbolic link

pointing to the Quick I/O name extension.

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

Usage notes

Creates a symbolic link with an absolute path name for a specified

file. Use the -a option when absolute path names are required.

However, the default is to create a symbolic link with a relative path

name.

-a

Extends a file by a specified amount to allow Oracle tablespace resizing.

See “Extending a Quick I/O file” on page 102.

-e

Specifies the Oracle datafile header size. This option specifies a header

that will be allocated in addition to the size specified because Oracle

requires one additional database block for all its datafiles. If this option

is used, the resulting file can be used as an Oracle datafile. When

creating an Oracle datafile, the header size should be equal to the

Oracle block size (as determined by the DB_BLOCK_SIZE parameter).

If the header size is missing when the -h option is used, a 32K header

will be allocated.

-h

Increases the file to a specified size to allow Oracle tablespace resizing.

See “Extending a Quick I/O file” on page 102.

-r

Improving database performance with Veritas Quick I/O

Creating database files as Quick I/O files using qiomkfile