DBWR write chunk

From: <argosy22_at_my-deja.com>
Date: Fri, 02 Feb 2001 17:31:00 GMT
Message-ID: <95eqsl$9bs$1@nnrp1.deja.com>

HI all,

I run this query in Oracle 8.1.7 and get info on the DBWR write chunk:

Select *
from X$KVII

ADDR           INDX    INST_ID    KVIIVAL KVIITAG
                           KVIIDSC
-------- ---------- ---------- ----------


--------------------------------------

--------------------------

-----------------------------------------------------

093D9490          6          1        160 kcbscw
                           DBWR write chunk

The OS block size is: 512 bytes.
512 / 160 = 3.2

The DB_BLOCK_SIZE is 8K (8192)
8192 / 160 = 51.2

These are uneven numbers, meaning that the drives would be working too hard if they were writing in chunks of 160 bytes.

If this was in kilobytes, then this would divide evenly.

160K / 8K = 20

But the odd thing is that the smallest extents that I have created are 128K.

Where can I find more info on this parameter? What is it measured in? Bytes? Is it possible to modify it? How?

Thanks

Sent via Deja.com
http://www.deja.com/ Received on Fri Feb 02 2001 - 11:31:00 CST