RE: db_file_multiblock_read_count and performance
- From: ryan_gaffuri@xxxxxxxxxxx
- To: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
- Date: Mon, 06 Dec 2004 19:47:10 +0000
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
lex,
we have system stats running here in production. we have about 500,000 users
and about 100 GB of space. We are noticing no improvement in the percentage of
queries that generate acceptable plans. if we set the index parameters more
appropriate 'even with' system stats, we get an improvement. System stats by
itself does not appear to help at all.
> CBO costs, though;
> The only thing you do while playing with the parameter is to make CBO
> *believe* that full table scans will be cheaper. In 9.2, enable system stats
> gathering and run your jobs --
> Then you will see the average number of blocks actually achieved by the
> multi block reads...
> Tom Kyte Seminar: http://www.naturaljoin.nl/events/seminars.html
> ----------------------------------------------------------------
-- Attached file included as plaintext by Ecartis --
From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
To: <ryan_gaffuri@xxxxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
Subject: RE: db_file_multiblock_read_count and performance
Date: Mon, 6 Dec 2004 17:49:54 +0000
Content-Type: Multipart/mixed;
boundary="NextPart_Webmail_9m3u9jl4l_6038_1102362430_2"
--NextPart_Webmail_9m3u9jl4l_6038_1102362430_2
Content-Type: text/x-vcard;
name="Lex de Haan.vcf"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="Lex de Haan.vcf"
BEGIN:VCARD
VERSION:2.1
N:de Haan;Lex
FN:Lex de Haan
ORG:Natural Join B.V.
TEL;WORK;VOICE:+31.30.2515022
TEL;HOME;VOICE:+31.30.2518795
TEL;CELL;VOICE:+31.62.2955714
TEL;WORK;FAX:+31.30.2523366
ADR;WORK:;;Pieter Breughelstraat 10;Utrecht;;3583 SK;Netherlands
LABEL;WORK;ENCODING=3DQUOTED-PRINTABLE:Pieter Breughelstraat =
10=3D0D=3D0AUtrecht 3583 SK=3D0D=3D0ANetherlands
URL;WORK:http://www.naturaljoin.nl
EMAIL;PREF;INTERNET:lex.de.haan@xxxxxxxxxxxxxx
REV:20040224T160439Z
END:VCARD
--NextPart_Webmail_9m3u9jl4l_6038_1102362430_2--
--
//www.freelists.org/webpage/oracle-l
Other related posts:
