Veritas Storage Foundation for Oracle 5.0 Administrator's Guide, HP-UX 11i v3, Second Edition, December 2008

size 100M reuse \

temporary;

Tablespace created.

This example shows how to drop tablespace tempts, create a Quick I/O file

temp01.dbf, and then create a new temporary tablespace tempts using the create

temporary tablespace command:

$ sqlplus /nolog

SQL> connect / as sysdba;

SQL> drop tablespace tempts including contents;

Tablespace dropped.

$ /opt/VRTS/bin/qiomkfile -h 32k -s 100M /db01/temp01.dbf

$ sqlplus /nolog

SQL> connect / as dba;

SQL> create temporary tablespace tempts \

tempfile '/db01/temp01.dbf' \

size 100M reuse;

Tablespace created.

Displaying Quick I/O status and file attributes

You can obtain and display information about Quick I/O status and file attributes

using various options of the ls command:

Lists all files on a file system, including Quick I/O files and their links.-al

Shows if Quick I/O was successfully installed and enabled.-1L

Shows how a Quick I/O file name is resolved to that of a raw device.-a1L

Using Veritas Quick I/O

Displaying Quick I/O status and file attributes