--MS_Mac_OE_3075396610_4810850_MIME_Part
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit
Srinagesh:
A couple of questions:
1. You have what seem to me to be many very large log groups. What reasons
make this necessary?
2. Have you considered setting LOG_CHECKPOINT_INTERVAL to a much lower value
that would compute to be less than the size of your redo logs so that
checkpoints would be forced in the middle of your redo logs as well as at
log switches? Forcing checkpoints within your log files reduces the time
needed for instance recovery.
3. What about setting LOG_CHECKPOINT_TIMEOUT to a lower value for the same
reasoning?
4. What have you found when setting the FAST_START_IO_TARGET parameter to a
lower value?
--
Jon Walthour, OCDBA
Oracle DBA
Computer Horizons
Cincinnati, Ohio
Organization: Fat City Network Services, San Diego, California
Reply-To: [EMAIL PROTECTED]
Date: Thu, 14 Jun 2001 15:45:42 -0800
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
RDBMS:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
OS:
SunOS e6500a 5.6 Generic_105181-19 sun4u sparc SUNW,Ultra-Enterprise
The init params are set as follows:
..
db_block_size=8192
db_block_buffers=20000
fast_Start_io_target=5000
log_checkpoints_to_alert = TRUE
log_checkpoint_timeout = 2147483647
log_checkpoint_interval = 999999999
....
We have 4 Redo log groups with 200M each.
We have a requirement that the instance recovery must be done within 60
secs.
So, we are trying to use the fast_Start_io_target param.
The issue here is, we don't see any checkpoints being done (as seen in the
alert logs as well as v$sysstat). THe only checkpoints that we see are the
ones that happen during a log switch or if you issue "alter system
checkpoint".
Any ideas on why the checkpoints are not being performed.
Thanks in advance.
--MS_Mac_OE_3075396610_4810850_MIME_Part
Content-type: text/html; charset="US-ASCII"
Content-transfer-encoding: quoted-printable
<HTML>
<HEAD>
<TITLE>Re: CKPTs are not happening with FAST_START_IO_TARGET </TITLE>
</HEAD>
<BODY>
Srinagesh:<BR>
<BR>
A couple of questions:<BR>
<BR>
1. You have what seem to me to be many very large log groups. What reasons =
make this necessary?<BR>
<BR>
2. Have you considered setting LOG_CHECKPOINT_INTERVAL to a much lower valu=
e that would compute to be less than the size of your redo logs so that chec=
kpoints would be forced in the middle of your redo logs as well as at log sw=
itches? Forcing checkpoints within your log files reduces the time needed fo=
r instance recovery.<BR>
<BR>
3. What about setting LOG_CHECKPOINT_TIMEOUT to a lower value for the same =
reasoning?<BR>
<BLOCKQUOTE><BR>
</BLOCKQUOTE>4. What have you found when setting the FAST_START_IO_TARGET p=
arameter to a lower value?<BR>
<BR>
-- <BR>
<BR>
Jon Walthour, OCDBA<BR>
Oracle DBA<BR>
Computer Horizons<BR>
Cincinnati, Ohio<BR>
<BR>
<BR>
<B>From: </B>Srinagesh Battula <[EMAIL PROTECTED]><BR>
<BLOCKQUOTE><B>Organization: </B>Fat City Network Services, San Diego, Cali=
fornia<BR>
<B>Reply-To: </B>[EMAIL PROTECTED]<BR>
<B>Date: </B>Thu, 14 Jun 2001 15:45:42 -0800<BR>
<B>To: </B>Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>=
;<BR>
<B>Subject: </B>CKPTs are not happening with FAST_START_IO_TARGET <BR=
>
<BR>
</BLOCKQUOTE><BR>
<BLOCKQUOTE><BR>
<BR>
<FONT SIZE=3D"2">RDBMS:</FONT> <BR>
<FONT SIZE=3D"2">Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production <=
BR>
With the Partitioning option <BR>
JServer Release 8.1.7.0.0 - Production <BR>
</FONT><BR>
<FONT SIZE=3D"2">OS:</FONT> <BR>
<FONT SIZE=3D"2">SunOS e6500a 5.6 Generic_105181-19 sun4u sparc SUNW,Ultra-En=
terprise <BR>
</FONT><BR>
<FONT SIZE=3D"2">The init params are set as follows: <BR>
.. <BR>
db_block_size=3D8192 <BR>
db_block_buffers=3D20000 <BR>
fast_Start_io_target=3D5000 <BR>
log_checkpoints_to_alert =3D TRUE <BR>
log_checkpoint_timeout =3D 2147483647 <BR>
log_checkpoint_interval =3D 999999999 <BR>
.... <BR>
</FONT><BR>
<FONT SIZE=3D"2">We have 4 Redo log groups with 200M each. <BR>
</FONT><BR>
<FONT SIZE=3D"2">We have a requirement that the instance recovery must be don=
e within 60 secs. <BR>
So, we are trying to use the fast_Start_io_target param. <BR>
The issue here is, we don't see any checkpoints being done (as seen in the =
alert logs as well as v$sysstat). THe only checkpoints that we see are the o=
nes that happen during a log switch or if you issue "alter system check=
point". <BR>
</FONT><BR>
<FONT SIZE=3D"2">Any ideas on why the checkpoints are not being perform=
ed.</FONT> <BR>
<BR>
<FONT SIZE=3D"2">Thanks in advance.</FONT> <BR>
</BLOCKQUOTE><BR>
</BODY>
</HTML>
--MS_Mac_OE_3075396610_4810850_MIME_Part--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jon Walthour
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
