oracle & db files

[Igaduma]

Hi all,

I'm wondering, does some1 have any experience with running a small database (2 gb, spread over 3 files) and mounting the db files on the oracle server as a remote directory from an nfs server ?

 

[lfoata]

Not a good idea. You are going to get very very poor performance from your RDBMS. NFS is just about the wrost tool when it comes to performance. Too bad I.T. is not cash business

Luc Foata
Unix sysadmin, Oracle DBA

 

[Annihilannic]

It's better than SMB!! SMB requires something like 7 function calls to open and read a file, versus 3 or so in NFS. Annihilannic.

 

[Igaduma]

Hi all,

I have to admit...i tried it....
and it's running *great*
The export from oracle goes *loads* faster and the frontend of the oracle database (some telecom data sucking tool) is faster in use and has a general better respons,

The NFS server is a dedicated ultra10 with them good old 2x6 multipacks ultrascsi next to it, I'm running it with 2 scsi controllers & a simple striped setup, i've stripped it from any other service, disabled the LAN and got it talking to only the db server over a 100Mb full duplex connection,
runs sweet.

nice.


Iga