RE: db_file_multiblock_read_count and performance

From: Gogala, Mladen <MGogala_at_allegientsystems.com>
Date: Mon, 6 Dec 2004 15:51:18 -0500
Message-ID: <D42C14B2E3F2B74DB41D5B6B2E2B992F01931F53@pegasus.lawaudit.com>

Of course, you could gather system statistics and let the system determine the optimal MBRC during the time of high load. That would actually save you from oscillating between minimum and maximum and trying to guess the best value. What is in your SYS.AUX_STATS$ table?
--

Mladen Gogala
Ext. 121

-----Original Message-----

From: ryan_gaffuri_at_comcast.net [mailto:ryan_gaffuri_at_comcast.net] Sent: Monday, December 06, 2004 2:52 PM
To: Waleed.Khedr_at_FMR.COM; Oracle-L_at_freelists.org Cc: Khedr, Waleed
Subject: RE: db_file_multiblock_read_count and performance

the maximum possible db_file_multiblock_read_count is 128. if you set it to this value and do a full tablescan then read the trace file you can get your 'actual' max readcount.
look at db file scattered reads p3 values. look for the max value.

--

http://www.freelists.org/webpage/oracle-l Received on Mon Dec 06 2004 - 15:04:58 CST