From: argosy22@my-deja.com
Newsgroups: comp.databases.oracle.server
Subject: DBWR write chunk
Date: Fri, 02 Feb 2001 17:31:00 GMT
Organization: Deja.com
Lines: 52
Message-ID: <95eqsl$9bs$1@nnrp1.deja.com>
NNTP-Posting-Host: 64.3.166.59
X-Article-Creation-Date: Fri Feb 02 17:31:00 2001 GMT
X-Http-User-Agent: Mozilla/4.75 [en] (Windows NT 5.0; U)
X-Http-Proxy: 1.0 router:3128 (Squid/2.3.STABLE4), 1.0 x67.deja.com:80 (Squid/1.1.22) for client 192.168.200.196, 64.3.166.59
X-MyDeja-Info: XMYDJUIDargosy22


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/