| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Symbolic Links on Sun Solaris 5.8/Oracle9.2
Hi Babu,
Our largest DB is small in the Oracle world -- only 30GB. But even if our DB grows to TB-level, I think I'd still rather treat the physical placement of the datafiles with logical volumes (i.e. more mountpoints) instead of using symlinks on the filesystem.
But then again, I don't follow OFA to a tee. I do like much of OFA, but one part that really bugs me is the placement of datafiles in the same tree as the software. So, while our Oracle software is generally installed on Unix/Linux in /opt/oracle, our datafiles generally reside in /oracle/SID. And for our "large" DBs or where I/O performance is perceived to be critical (and the budget supported it), we've broken out the /oracle/SID directory into /oracle/SID/sid0, /oracle/SID/sid1, /oracle/SID/sid2, etc, with each directory being a separate logical volume (and therefore, mountpoint).
HTH! GL!
Rich
Rich Jesse System/Database Administrator rich.jesse_at_quadtechworld.com QuadTech, Sussex, WI USA
> -----Original Message-----
> From: Janardhana Babu Donga [mailto:jbdonga_at_ucdavis.edu]
> Sent: Wednesday, April 21, 2004 5:44 PM
> To: 'oracle-l_at_freelists.org'
> Cc: Jesse, Rich
> Subject: RE: Symbolic Links on Sun Solaris 5.8/Oracle9.2
>
>
> How do you guys use while creating the database? Do you
> specify direct path
> as in OFA (/mountpoint/oradata/sid/data01.dbf) or use
> directory soft links
> for all the datafiles? What procedures do you follow for
> medium to large
> databases?
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu Apr 22 2004 - 10:12:14 CDT
 |
 |