you can get 1MB per I/O on a SAN. Pretty helpful for data loads or large scale reporting. If you have a standard blocksize of 8KB, you can set your DB_FILE_MULTI_BLOCK=128. doing this could make full table scans more likely(its not as often as alot of people think acording to my tests) so test your queries. it doesn't do much of anything for straight OLTPs since your almost always using indexes and getting 1 block per I/O anyway. > > From: "Kommareddy, Srinivas (MED, Wissen Infotech)" > <Srinivas.Kommareddy@xxxxxxxxxx> > Date: 2004/03/22 Mon AM 02:31:22 EST > To: oracle-l@xxxxxxxxxxxxx > Subject: NAS to SAN > > > Hi All, > > OS: 2.8 Solaris > > We (DBAs) were informed recently that we were moving from NAS to SAN and > we were asked to move oracle apps stack (APPL_TOPs and COMMON_TOPs) > files from /u02 to /u02_new (new mountpoint) and once we were done, /u02 > was renamed as /u02_old and /u02_new was renamed as /u02.(our apps > started using new SAN mountpoint /u02). > > Could somebody through somelight on this process NAS to SAN, > what are the benefits from NAS to SAN and > is there a way to identify is a disk related to SAN. > > ________________________ > Srinivas Reddy K > Database Administrator (ODC), > Wissen Infotech Pvt. Ltd., > Phone: (+91) 40-55313031, (+91) 40-27892897 > E-Mail: <mailto:Chary.Podichetty@xxxxxxxxxx> > Srinivas.Kommareddy@xxxxxxxxxx > Visit Us On The Internet: <http://www.wisseninfotech.com/> > http://www.wisseninfotech.com > > >
Hi All, OS: 2.8 Solaris We (DBAs)
were informed recently that we were moving from NAS to SAN and we were asked to
move oracle apps stack (APPL_TOPs and COMMON_TOPs) files from /u02 to /u02_new (new mountpoint) and once we were done, /u02 was renamed as
/u02_old and /u02_new was renamed as /u02.(our apps
started using new SAN mountpoint /u02). Could somebody through somelight on this process NAS to SAN,
what are the
benefits from NAS to SAN and is there a
way to identify is a disk related to SAN. ________________________ Srinivas Reddy K Database Administrator (ODC), Wissen Infotech Pvt. Ltd., Phone: (+91)
40-55313031, (+91) 40-27892897 E-Mail: Srinivas.Kommareddy@xxxxxxxxxx Visit Us On The
Internet: http://www.wisseninfotech.com |