VERITAS File SystemÖ 3.5 (HP OnlineJFS/JFS3.5) AdministratorÆs Guide (December 2002)

Chapter 8

Quick I/O for Databases

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 (typically user ID oracle):

$ qiomkfile -h -s 100m /database/dbfile

$ svrmgrl

SVRMGR> connect internal

SVRMGR> create tablespace ts1

SVRMGR> datafile ’/database/dbfile’ size 100M;

SVRMGR> 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.

$ svrmgrl

SVRMGR> connect internal

SVRMGR> create tablespace ts1

SVRMGR> datafile ’/database/dbfile’ size 99M;

SVRMGR> exit;