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

Home -> Community -> Usenet -> c.d.o.server -> Re: v$filestat

Re: v$filestat

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 8 Mar 2001 10:27:40 -0000
Message-ID: <984047329.17926.0.nnrp-14.9e984b29@news.demon.co.uk>

This is only for direct writes from sorts, index builds, direct loads, CTAS, etc. which reminds me that hash_multiblock_io_count is good for multi-block writes too.

Any writes that go through dbwr/cache
are single block writes.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Nuno Souto wrote in message <3aa75761.4759524_at_news-server>...

>On Thu, 8 Mar 2001 09:23:21 -0000, "Jonathan Lewis"
><jonathan_at_jlcomp.demon.co.uk> wrote:
>
>Thanks, Jonathan.
>Is that one reliable and consistent with the ratio of writes to block
>writes? Ie, does dbwr actually sequence blocks from the cache to make
>them write sequentially in a single command? Or is it just a multiple
>write command initiation, no actual physical sequence involved?
>
>>
>>db_file_direct_io_count ?
>>
>>(only in 8+)
>>
>>--
>>Jonathan Lewis
>>Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Received on Thu Mar 08 2001 - 04:27:40 CST

Original text of this message

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