Re: Can database files be NFS mounted.

Chuck Hamilton wrote:
>
> Charles Jardine <cj10_at_cam.ac.uk> wrote:
>
> >Is it OK for the files which make up an Oracle database to be
> >NFS mounted, or must they be on discs directly attached to
> >the server machine?
> >
> >I have always believed that NFS mounting of database files was
> >forbidden. However, I cannot now find any reference to this
> >restriction in the documentation. I am sure that I once read it
> >somewhere (perhaps back in Oracle 6 days).
> >
> >I would be very grateful if anyone can give a definitive answer
> >to this question (particularly with a documentation reference).
> >
> >Charles Jardine - Univ. of Cambridge (UK) Computing Service
>
> I've never tried it but I would think this would be a bad idea just
> for performance reasons, both for the database and the network. You'll
> probably suck up all your bandwidth, not to mention that few networks
> are going to be as fast as a local disk drive.
>
> Why not create a test database and try it? Make sure to test
> everything though: queries, updates, backup & recovery, etc. If you
> do, please post the results. I'd be interested in hearing what
> happened
> --
> Chuck Hamilton
> chuckh_at_dvol.com
>
> Never share a foxhole with anyone braver than yourself!

Been there and done it!! Yes, it works, but as Chuck said, it is very slow.

-- 
Ashok Kapur (akapur_at_thomtech.com)
Thomson Technology Consulting Group
1375 Piccard Drive, Suite 250
Rockville, MD 20850