| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> UNIX fstab settings and prealloc command
This is a multi-part message in MIME format.
------_=_NextPart_001_01C2F249.90D4BA30
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
We're running online JFS on HP. We had a recommendation given to us =
to replace the settings in fstab for the online redo logs and archive =
logs. The settings were:
=20
/dev/vgPRD03/lvPRDsaparch /oracle/PRD/saparch vxfs delaylog 0 =
=20
/dev/vgPRD02/lvPRDoriglogB /oracle/PRD/origlogB vxfs delaylog 0 =
=20
/dev/vgPRD01/lvPRDoriglogA /oracle/PRD/origlogA vxfs delaylog 0 =
=20
/dev/vgPRD01/lvPRDmirrlogB /oracle/PRD/mirrlogB vxfs delaylog 0 =
=20
/dev/vgPRD03/lvPRDsaparch /oracle/PRD/saparch vxfs = nodatainlog,convosync=3Ddirect 0 =20 /dev/vgPRD02/lvPRDoriglogB /oracle/PRD/origlogB vxfs = nodatainlog,convosync=3Ddirect 0 =20 /dev/vgPRD01/lvPRDoriglogA /oracle/PRD/origlogA vxfs = nodatainlog,convosync=3Ddirect 0 =20 /dev/vgPRD01/lvPRDmirrlogB /oracle/PRD/mirrlogB vxfs = nodatainlog,convosync=3Ddirect 0 =20 /dev/vgPRD02/lvPRDmirrlogA /oracle/PRD/mirrlogA vxfs = nodatainlog,convosync=3Ddirect 0 =20=20
/oracle/DV1/origlogA vxfs delaylog,convosync=3Ddirect 0 2 /oracle/DV1/origlogB vxfs delaylog,convosync=3Ddirect 0 2 /oracle/DV1/mirrlogA vxfs delaylog,convosync=3Ddirect 0 2 /oracle/DV1/mirrlogB vxfs delaylog,convosync=3Ddirect 0 2=20
which indicated a slight negative impact to I/O with the nodatainlog. = I've read the man pages on prealloc, but it isn't clear that this is a = valid simulation of the online redo logs. Does anyone have experience =with this? Was this a valid test?
------_=_NextPart_001_01C2F249.90D4BA30
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DISO-8859-1">
<META content=3D"MSHTML 5.50.4919.2200" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D411085820-24032003><FONT face=3DArial=20
size=3D2>Hi,</FONT></SPAN></DIV>
<DIV><SPAN class=3D411085820-24032003><FONT face=3DArial size=3D2> =
We're running=20
online JFS on HP. We had a recommendation given to us to replace =
the=20
settings in fstab for the online redo logs and archive logs. The =
settings=20
were:</FONT></SPAN></DIV>
<DIV><SPAN class=3D411085820-24032003><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D411085820-24032003><FONT face=3DArial color=3D#0000ff =
size=3D2>/dev/vgPRD03/lvPRDsaparch =20
/oracle/PRD/saparch vxfs delaylog =20
0 =20
<BR>/dev/vgPRD02/lvPRDoriglogB =20
/oracle/PRD/origlogB vxfs delaylog =20
0 =20
<BR>/dev/vgPRD01/lvPRDoriglogA =20
/oracle/PRD/origlogA vxfs delaylog =20
0 =20
<BR>/dev/vgPRD01/lvPRDmirrlogB =20
/oracle/PRD/mirrlogB vxfs delaylog =20
0 =20
<BR>/dev/vgPRD02/lvPRDmirrlogA =20
/oracle/PRD/mirrlogA vxfs delaylog =20
0</FONT></SPAN></DIV>
<DIV><SPAN class=3D411085820-24032003><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D411085820-24032003><FONT face=3DArial size=3D2>The =
recommended=20
change would be:</FONT></SPAN></DIV>
<DIV><SPAN class=3D411085820-24032003><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D411085820-24032003><FONT face=3DArial color=3D#0000ff =
size=3D2>/dev/vgPRD03/lvPRDsaparch =20
/oracle/PRD/saparch vxfs =20
nodatainlog,convosync=3Ddirect =20
0 =20
<BR>/dev/vgPRD02/lvPRDoriglogB =20
/oracle/PRD/origlogB vxfs =20
nodatainlog,convosync=3Ddirect =20
0 =20
<BR>/dev/vgPRD01/lvPRDoriglogA =20
/oracle/PRD/origlogA vxfs =20
nodatainlog,convosync=3Ddirect =20
0 =20
<BR>/dev/vgPRD01/lvPRDmirrlogB =20
/oracle/PRD/mirrlogB vxfs =20
nodatainlog,convosync=3Ddirect =20
0 =20
<BR>/dev/vgPRD02/lvPRDmirrlogA =20
/oracle/PRD/mirrlogA vxfs =20
nodatainlog,convosync=3Ddirect =20
0 </FONT></SPAN></DIV>
<DIV><SPAN class=3D411085820-24032003><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D411085820-24032003><FONT face=3DArial size=3D2>What a =
different=20
branch of the consultants gave us was:</FONT></SPAN></DIV>
<DIV><SPAN class=3D411085820-24032003><FONT face=3DArial color=3D#0000ff =
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D411085820-24032003><FONT face=3DArial color=3D#0000ff =
size=3D2>/oracle/DV1/origlogA vxfs delaylog,convosync=3Ddirect 0=20 2<BR>/oracle/DV1/origlogB vxfs delaylog,convosync=3Ddirect 0=20 2<BR>/oracle/DV1/mirrlogA vxfs delaylog,convosync=3Ddirect 0=20 2<BR>/oracle/DV1/mirrlogB vxfs delaylog,convosync=3Ddirect 0=20 2</FONT></SPAN></DIV>
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D411085820-24032003><FONT face=3DArial size=3D2>They =
based this on a=20
quick test using the following command:</FONT></SPAN></DIV>
<DIV><SPAN class=3D411085820-24032003><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D411085820-24032003><FONT size=3D2><FONT face=3DArial=20
color=3D#0000ff>/bin/time -p prealloc myfile =
1000000000</FONT></FONT></SPAN></DIV>
<DIV><SPAN class=3D411085820-24032003><FONT size=3D2><FONT face=3DArial=20
color=3D#0000ff></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=3D411085820-24032003><FONT size=3D2><FONT =
face=3DArial>which=20
indicated a slight negative impact to I/O with the nodatainlog. =
I've read=20
the man pages on prealloc, but it isn't clear that this is a valid =
simulation of=20
the online redo logs. Does anyone have experience with this? =
Was=20
this a valid test?</FONT></FONT></SPAN></DIV>
<DIV><SPAN class=3D411085820-24032003><FONT size=3D2><FONT=20
face=3DArial></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=3D411085820-24032003><FONT size=3D2><FONT =
face=3DArial>Best=20
regards,</FONT></FONT></SPAN></DIV>
<DIV><SPAN class=3D411085820-24032003><FONT size=3D2><FONT =
Received on Mon Mar 24 2003 - 15:08:49 CST
 |
 |