Re: v$filestat

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: Thu, 08 Mar 2001 10:14:02 GMT
Message-ID: <3aa75761.4759524@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
>
>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 <3aa7498d.1219024_at_news-server>...
>>On Wed, 7 Mar 2001 15:11:30 -0500, "LF" <frolio_at_videoshare.com> wrote:
>>
>>Same for writes, but things get slightly more complicated there: there
>>is no such parameter as "db_file_multiblock_writes"... ;-)
>>
>
>
>

Cheers
Nuno Souto
nsouto_at_bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Thu Mar 08 2001 - 04:14:02 CST