Re: ?? X$KSVII fixed table not found (Jonathan - this is one of yours)

I don't think there is a document with this answer. I do know that some time ago I had an I/O problem and discovered that the x$ value was running at 4096 when the calculations should have given a value of 256. When I set the value explicitly the I/O problem went away.

So -

DB_FILES_SIMULATEOUS_WRITES and DB_FILES to something very large and see what the x$ gives you - this will presumably be the platform limit. (or the size of db_block_buffers, whichever is smaller possibly).

--

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

Kevin A Lewis wrote in message ...
>Top notch !!
>
>Supplementary question then - in the Oracle Tuning manuals for 8.0 and 8.1
>in the section on 'Tuning DBWn I/O' it mentions the Internal Write Batch
>Size. It then defines this as having the smaller value of three possible
>sources A B and C.
>
>I can calculate the value A (DB_FILES * DB_FILES_SIMULATEOUS_WRITES / 2). I
>have even less trouble calculating the value of C (1/4 of
DB_BLOCK_BUFFERS).
>But finding the value of C from 'Oracle platform specific documentation' is
>the real 'toughie'.
>
>We use OpenVMS on VAX and ALPHA,
> Tru64UNIX on ALPHA
>& Windows NT & 95 on Compaq Intel
>
>And I am having considerable trouble finding the appropriate figure from
the
>documentation for each platform. Is it possible you know the answers of
>better the location in the manuals of the answers.
>
>Thanks in advance
>
>Regards
>
>--
>Kevin A Lewis (BOCM PAULS LTD) - Animal Feed Manufacturer - Ipswich United
>Kingdom)
> <Kevin_A_Lewis_at_Hotmail.com>
>
>The views expressed herein by the author of this document
>are not necessarily those of BOCM PAULS Ltd.
>Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote in message
>news:948298383.11895.0.nnrp-06.9e984b29_at_news.demon.co.uk...
>>
>> Apologies for the typo - it is x$kvii.
>> The specific row is
>> kcbswc, DB writer IO clump
>>
>> --
>>
>> Jonathan Lewis
>> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>>
>> Kevin A Lewis wrote in message
>> <4rkh4.2204$hr4.41104_at_newreader.ukcore.bt.net>...
>> >Jonathan Lewis quoted this fixed table ( X$KSVII) as the holder of the
>> >actual value for _db_block_write_batch
>> >
>> >However using 8.0.5 I can find no such table. Could it be X$KVII and if
>so
>> >which row would be the correct one.
>> >
>> >Regards
>> >
>> >--
>> >Kevin A Lewis (BOCM PAULS LTD) - Animal Feed Manufacturer - Ipswich
>United
>> >Kingdom)
>> > <Kevin_A_Lewis_at_Hotmail.com>
>> >
>> >The views expressed herein by the author of this document
>> >are not necessarily those of BOCM PAULS Ltd.
>> >
>> >
>>
>>
>
>
Received on Thu Jan 20 2000 - 12:58:10 CST