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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBWR Mystery

RE: DBWR Mystery

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Fri, 8 Sep 2000 10:09:22 +1000
Message-Id: <10612.116473@fatcity.com>


Hi Gautam,

Where does your understanding of kcbscc come from? My tests (and the documentation) indicate that it is an absolute number of buffers rather than a percentage.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/

@

@ Going to OpenWorld?
@ Catch the Ixora performance tuning seminar too!
@ See http://www.ixora.com.au/seminars/ for details.

-----Original Message-----
From: Reddy, Gautam [mailto:Gautam_Reddy_at_Dell.com] Sent: Friday, 8 September 2000 9:06
To: Multiple recipients of list ORACLE-L Subject: RE: DBWR Mystery

Gopal
This should clear you doubts.

kcbsdl -: When DBWR is posted to make free buffer, it scans up to N buffers in LRU list ( from TAIL to HEAD) looking for dirty buffer . To simplify, N is adjusted between kcbsdl and kcbsdh .

kcbscc -: DB writer checkpoint clump = percentage of write batch for low priority checkpoint request. When DBWR performs checkpoint, it tries to advance every pending checkpoint-request by writing buffers . For low priority checkpoint request, the total number of buffers that will be flushed is (kcbscc/100)*kcbswc

Let me know if I can be of more help.

Thx
Gautam

-----Original Message-----
Sent: Thursday, August 31, 2000 3:47 AM
To: Multiple recipients of list ORACLE-L

Hi ..

I am getting confused with the following DBWR related TAGs .

 50 kcbswc DB writer IO clump
 16 kcbscc DB writer checkpoint clump
 13 kcbsdl DBWR blocks to scan lowest value  50 kcbsdh DBWR blocks to scan highest value   5 kcbsdi DBWR scan depth increment
 50 kcbsfs foreground blocks to scan looking for free 200 kcbnbh number buffer headers
247 kcbnbf number buffer objects

Total number of buffers =200 and the DBWR Write batch size is 50. (i.e IO Clump).. But there are two more otehr tags (kcbsfs and kcbsdh) are also 50. Does that mean DBWR will scan so buffers (kcbnbh/4) all the times whenever you need a free buffer in the hash chain. And what is the difference between kcbscc and kcbsfs.(both are kcbnbh/4 here).

And the other point of confusion here is the difference in checkpoint clump and IO clump. What parameter (or algorithm ) used in deciding the and kcbscc .

I am using Oracle 8.0.3 with no buffer pools configured if that matters.



Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/
--
Author: K Gopalakrishnan
  INET: kaygopal_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
also send the HELP command for other information (like subscribing).
--
Author: Reddy, Gautam
  INET: Gautam_Reddy_at_Dell.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 Thu Sep 07 2000 - 19:09:22 CDT

Original text of this message

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