Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8i Rel.2 on NFS

Re: Oracle 8i Rel.2 on NFS

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/06/20
Message-ID: <961476734.23033.0.pluto.d4ee154e@news.demon.nl>#1/1

Yes, very simple:
Don't use it!
NFS is very much slower than normal disk operations, it is an inefficient protocol, and IMO, using network drives in an Oracle database environments is one of the safest ways to hell. I guess you are probably also running in noarchivelog mode? In that case I would say regular prayers to make sure havoc passes your doorstep instead of hit it. Please note that all of these protocols have one thing in common: your process isn't reading the disk. You are simply requesting a daemon to read the disk on your behalf. Needles to say these daemons become the bottleneck. One glitch, your database will crash, and you're out of business.

Regards,

Sybrand Bakker, Oracle DBA

"Sambavan Tharmarajah" <sambavan_at_cs.utexas.edu> wrote in message news:Pine.LNX.4.21.0006191515320.10481-100000_at_rattlesnake.cs.utexas.edu...
> Could someone advice me of the best way to install oracle 8i using NFS
> and sun solaris. I know there are around three ways to do it. But at this
> point would like to know, which one would have a best performance. I'm
> currently trying of putting both(software and database) on NFS and notice
> it to takes a hell a lot of time to create my database. But still don't
> know of the performance side. Could someone give me some advices on this
> case, and explore the merits of your suggestions?
>
> Thanx
> Sam .T
>
> -------------------------------------------------------
>
> What I do today is important because
> I'm exchanging a day of my life for it
>
> --------------------------------------------------------
>
Received on Tue Jun 20 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US