RE: control file parallel write

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Mon, 7 Aug 2000 12:29:17 +1000
Message-Id: <10581.113934@fatcity.com>

Hi Yong,

In answer to a similar question, available in the question and answer section of my web site for 3 March 2000 I wrote, "In 8.0.5 a heartbeat mechanism was included in CKPT's timeout action (every 3 seconds) to update the checkpoint progress record for the thread in the controlfile." However, the timeout being referred to here is the routine timeout of its 'rdbms ipc message' wait every 3 seconds, NOT the instance checkpoint timeout that is controlled by the log_checkpoint_timeout parameter. If you were to change that parameter to 2 you would notice a lot more than increased 'control file parallel write' waits. You would also notice very bad performance!

Regards,
Steve Adams

http://www.ixora.com.au/
http://www.oreilly.com/catalog/orinternals/
http://www.christianity.net.au/

-----Original Message-----
From: yong huang [mailto:yong321_at_yahoo.com] Sent: Monday, 7 August 2000 8:34
To: Multiple recipients of list ORACLE-L Subject: Re: cntrl file paralel write

Rahul,

The same happens to my database. It seems the CKPT process is touching the
control file every 3 seconds, presumably because the LGWR does its job every 3
seconds. If you change log_checkpoint_timeout to 2, you'll notice your control
file parallel write waits for redo log writing every 2 seconds.

Yong Huang
yong321_at_yahoo.com

you wrote:

List,
a new instance, just one user connected (SYS), select * from v$system_event shows that the
"control file parallel write" are increasing....!!
"total waits" are increasing by 10 per 30 seconds...
whenever i query the v$system_event i see an increase in the time_waited,waits in this event..

is this the one to ignore ?

8.1.5, AIX Rahul

P1TEXT = files
P1 = 3
P2TEXT = blocks
P2 = 3
P3TEXT = requests
P3 = 3

Do You Yahoo!?
Kick off your party with Yahoo! Invites. http://invites.yahoo.com/

--
Author: yong huang
  INET: yong321_at_yahoo.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

Received on Sun Aug 06 2000 - 21:29:17 CDT