Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> UNIX fstab settings and prealloc command

UNIX fstab settings and prealloc command

From: Brooks, Russ <Russ.Brooks_at_dayzim.com>
Date: Mon, 24 Mar 2003 16:08:49 -0500
Message-Id: <24765.322937@fatcity.com>


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/vgPRD02/lvPRDmirrlogA /oracle/PRD/mirrlogA vxfs delaylog 0 =20
The recommended change would be:
=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
What a different branch of the consultants gave us was: =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
They based this on a quick test using the following command: =20
/bin/time -p prealloc myfile 1000000000
=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?
=20
Best regards,
Russ Brooks
=20

------_=_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>&nbsp; =
We're running=20
online JFS on HP.&nbsp; We had a recommendation given to us to replace = the=20
settings in fstab for the online redo logs and archive logs.&nbsp; The = settings=20
were:</FONT></SPAN></DIV>
<DIV><SPAN class=3D411085820-24032003><FONT face=3DArial=20
size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D411085820-24032003><FONT face=3DArial color=3D#0000ff =

size=3D2>/dev/vgPRD03/lvPRDsaparch&nbsp;&nbsp;&nbsp;&nbsp;=20 /oracle/PRD/saparch&nbsp;&nbsp;&nbsp; vxfs&nbsp; delaylog&nbsp;&nbsp;=20 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<BR>/dev/vgPRD02/lvPRDoriglogB&nbsp;&nbsp;&nbsp;=20
/oracle/PRD/origlogB&nbsp;&nbsp; vxfs&nbsp; delaylog&nbsp;&nbsp;=20 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<BR>/dev/vgPRD01/lvPRDoriglogA&nbsp;&nbsp;&nbsp;=20
/oracle/PRD/origlogA&nbsp;&nbsp; vxfs&nbsp; delaylog&nbsp;&nbsp;=20 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<BR>/dev/vgPRD01/lvPRDmirrlogB&nbsp;&nbsp;&nbsp;=20
/oracle/PRD/mirrlogB&nbsp;&nbsp; vxfs&nbsp; delaylog&nbsp;&nbsp;=20 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<BR>/dev/vgPRD02/lvPRDmirrlogA&nbsp;&nbsp;&nbsp;=20
/oracle/PRD/mirrlogA&nbsp;&nbsp; vxfs&nbsp; delaylog&nbsp;&nbsp;=20 0</FONT></SPAN></DIV>
<DIV><SPAN class=3D411085820-24032003><FONT face=3DArial color=3D#0000ff =

size=3D2></FONT></SPAN>&nbsp;</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>&nbsp;</DIV>
<DIV><SPAN class=3D411085820-24032003><FONT face=3DArial color=3D#0000ff =

size=3D2>/dev/vgPRD03/lvPRDsaparch&nbsp;&nbsp;&nbsp;&nbsp;=20 /oracle/PRD/saparch&nbsp;&nbsp;&nbsp; vxfs&nbsp;=20 nodatainlog,convosync=3Ddirect&nbsp;&nbsp;=20 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<BR>/dev/vgPRD02/lvPRDoriglogB&nbsp;&nbsp;&nbsp;=20
/oracle/PRD/origlogB&nbsp;&nbsp; vxfs&nbsp;=20 nodatainlog,convosync=3Ddirect&nbsp;&nbsp;=20 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<BR>/dev/vgPRD01/lvPRDoriglogA&nbsp;&nbsp;&nbsp;=20
/oracle/PRD/origlogA&nbsp;&nbsp; vxfs&nbsp;=20 nodatainlog,convosync=3Ddirect&nbsp;&nbsp;=20 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<BR>/dev/vgPRD01/lvPRDmirrlogB&nbsp;&nbsp;&nbsp;=20
/oracle/PRD/mirrlogB&nbsp;&nbsp; vxfs&nbsp;=20 nodatainlog,convosync=3Ddirect&nbsp;&nbsp;=20 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
<BR>/dev/vgPRD02/lvPRDmirrlogA&nbsp;&nbsp;&nbsp;=20
/oracle/PRD/mirrlogA&nbsp;&nbsp; vxfs&nbsp;=20 nodatainlog,convosync=3Ddirect&nbsp;&nbsp;=20 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT></SPAN></DIV>
<DIV><SPAN class=3D411085820-24032003><FONT face=3DArial color=3D#0000ff =

size=3D2></FONT></SPAN>&nbsp;</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>&nbsp;</DIV>
<DIV><SPAN class=3D411085820-24032003><FONT face=3DArial color=3D#0000ff =

size=3D2>/oracle/DV1/origlogA vxfs delaylog,convosync=3Ddirect&nbsp; 0=20
2<BR>/oracle/DV1/origlogB vxfs delaylog,convosync=3Ddirect&nbsp; 0=20
2<BR>/oracle/DV1/mirrlogA vxfs delaylog,convosync=3Ddirect&nbsp; 0=20
2<BR>/oracle/DV1/mirrlogB vxfs delaylog,convosync=3Ddirect&nbsp; 0=20
2</FONT></SPAN></DIV>

<DIV><SPAN class=3D411085820-24032003><FONT face=3DArial color=3D#0000ff =

size=3D2></FONT></SPAN>&nbsp;</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>&nbsp;</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>&nbsp;</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.&nbsp; = 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.&nbsp; Does anyone have experience with this?&nbsp; = 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>&nbsp;</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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US