Showing results for 
Search instead for 
Did you mean: 

Oracle 8i on filesystem.


Oracle 8i on filesystem.

Hi all,
I want use filesystem for oracle 8i as the datafile.
please give me some advice on
I know a lot of people use raw lv to storage the oracle data.
but someone told me that we can get high performance use filesystem. :-)
Alexander M. Ermes
Honored Contributor

Re: Oracle 8i on filesystem.

Hi there.
You should setup your directories according to Oracle Flexible Architecture ( OFA ).
Check Oracle Metalink and your Oracle documentation for that.
Sample :

for offile redolog files

for alert logs and system traces

for Oracle coredumps / traces

for exports

for imports

for userdumps

for datafiles ( tablespaces )

for online logs

for controlfiles

/home/dba/oracle/admin/ORACLE_SID/arch linked to arch dir mentioned above

/home/dba/oracle/admin/ORACLE_SID/bdump as above

/home/dba/oracle/admin/ORACLE_SID/cdump as above

/home/dba/oracle/admin/ORACLE_SID/udump as above

/home/dba/oracle/admin/ORACLE_SID/create for sql scripts to create a database

/home/dba/oracle/admin/ORACLE_SID/exp for scripts and parfiles for exports

/home/dba/oracle/admin/ORACLE_SID/imp for scripts and parfiles for imports

/home/dba/oracle/admin/ORACLE_SID/sql for sql scripts

and so on.
Samples given in OFA.

keep away online logs from offline logs ( separate disks )

keep away index tablespaces from data tablespaces ( separate disks )

Keep control files away from the others

keep your application logs and output files seaparated.

this needs careful planning and may take some time to spread the different databases through the different mountpoints / disks / directories.

Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Bill Hassell
Honored Contributor

Re: Oracle 8i on filesystem.

Putting all the Oracle datafiles and executables on a single filesystem will have a tremendous impact on performance (it will be very slow). As mentioned, there are many different filesystems, each with very specific tasks and some are very write-intensive. These must be stored on separate disks for reasonable performance.

This is not as raw vs. filesystem question, it is a practical disk layout question. Separate the busiest filesystems onto different disks, even different controllers for optimum performance.

Bill Hassell, sysadmin
Andreas D. Skjervold
Honored Contributor

Re: Oracle 8i on filesystem.


In theory the raw device will give you a better performance, but I've read that the actual gain is minimal.

The advantage in using filesystem is the vastly easier administration of the database such as tablespace growth.

So go with Ernest suggestion, the OFA std. to spread the different part of Oracle on different mountpoints, ofcourse being on different disk drives.


Only by ignoring what everyone think is important, can you be aware of what everyone ignores!
Jason VanDerMark
Trusted Contributor

Re: Oracle 8i on filesystem.

The OFA standard is pretty good, but as it was already mentioned, it is not a good idea to put your most I/O intensive things into a single filesystem. I would suggest modifying the OFA by making secondary archives(gzipped archives, make DBAs all warm and fuzzy), secondary tablespace area(allows you to split the heavy hit tables on seperate filesystems.)
and even secondary index area(again for splitting up I/O). I hope that this helps.

Jason V.
Tie two birds together, eventhough they have four wings, they cannot fly.
Honored Contributor

Re: Oracle 8i on filesystem.


since you asked for "filesystem", I guess you want to know the special mount-options for the "Online" or "Advanced" JFS/VxFS:
are very useful if (and only if) you only have Oracle-datafiles stored on that filesystem - nothing else, no tracefile/textfile/codefiles, etc!
What happens, is that you avoid the so-called "double-buffering" of the Oracle-datablocks (from Oracle-SGA to UNIX-buffercache to disk), which saves a lot of RAM (and a little time). Then you dedicate that RAM to Oracle and THEN you are much faster :-)

Just my $0.02,