Hi -
I have all our Oracle9i databases defined as individual qtrees spread
over two filers. Some time ago the decision was to split an individual
database into 3 separate components (qtrees), one for the data
(tables) the other two qtrees for duplex logs, one on each filer head.
A Sun Solaris 8 dataserver that runs 6 Oracle databases then has 18 nfs mounts.
On the recommendation of NetApp the qtrees are mounted with these
options: rw,hard,intr,bg,proto=tcp,llock
The DBAs now would like to have this rearranged so that there is a
single qtree per dataserver host (think of this as one large blob of
space) with ALL of the databases that this server will run as a
sub-directory of this qtree.
I'm a bit worried over the resultant nfs performance all going though
this single mount point. Can someone comment on the issues of multiple
nfs mounts vs. a single mount ?
What about locking ?
Thanks,
George
This archive was generated by hypermail 2b29 : Tue Mar 15 2005 - 11:40:00 EST