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