Re: Filesystem for Oracle 9i

From: Pablo Sanchez <pablo_at_dev.null>
Date: 9 Sep 2002 10:24:27 -0500
Message-ID: <Xns92845FB629B73pingottpingottbah@192.168.1.1>

"Jeff Barnes" <barnesjw_at_dfo-mpo.gc.ca> wrote in news:GB2f9.2052$i%.517005_at_localhost:

> Does anyone have any recommendations or advice concerning the
> installation of Oracle 9i on a standalone (non-clustered) Alpha
> DS-20E running Tru64 5.1A? Notably with repect to filesystems
> (AdvFS, RAW, UFS....), patchkits, array configurations etc. All
> relavent information is welcome.

If performance is what you're after, your best bet is to use RAW. If your O/S and your port of Oracle supports direct I/O, then if you are inclined to do regular files, the performance penalty isn't that great (on writes).

As a side note, try use 'symbolic links' when you're building your instance. It'll give you the most flexibility by building a layer of abstraction between the underlying filesystem and the instance.

HTH!

-- 
Pablo Sanchez, High-Performance Database Engineering
http://www.hpdbe.com

Received on Mon Sep 09 2002 - 10:24:27 CDT