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

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 - 04:31:48 CST