VERITAS File System 4.1 Administrator's Guide

Quick I/O for Databases
Using Quick I/O with Oracle Databases
Chapter 11170
Using Quick I/O with Oracle Databases
The following example shows how a file can be used by an Oracle database to create a
tablespace. This command would be run by the Oracle DBA (Using the user ID oracle):
$ qiomkfile -h headersize -s 100m /database/dbfile
$ sqlplus /nolog
SQL> connect / as sysdba
SQL> create tablespace ts1 datafile ’/database/dbfile’ size 100M;
SQL> exit;
The following example shows how the file can be used by an Oracle database to create a
tablespace. Oracle requires additional space for one Oracle header size. So in this example,
although 100 MB was allocated to /database/dbfile, the Oracle database can use only up to
100 MB minus the Oracle parameter db_block_size.
$ sqlplus /nolog
SQL> connect / as sysdba
SQL> create tablespace ts1 datafile ’/database/dbfile’ size 99M;
SQL> exit;