| 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: CKPTs are not happening with FAST_START_IO_TARGET
--MS_Mac_OE_3075396610_4810850_MIME_Part
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit
Srinagesh:
A couple of questions:
-- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio Organization: Fat City Network Services, San Diego, California Reply-To: ORACLE-L_at_fatcity.com Date: Thu, 14 Jun 2001 15:45:42 -0800 To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> 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-printableReceived on Thu Jun 14 2001 - 19:39:54 CDT
<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 <sbattula_at_vcommerce.com><BR>
<BLOCKQUOTE><B>Organization: </B>Fat City Network Services, San Diego, Cali=
fornia<BR>
<B>Reply-To: </B>ORACLE-L_at_fatcity.com<BR>
<B>Date: </B>Thu, 14 Jun 2001 15:45:42 -0800<BR>
<B>To: </B>Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>=
;<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: jwalthour_at_mac.com 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: ListGuru_at_fatcity.com (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).
 |
 |