Re: optimizer_index_cost_adj and optimizer_index_caching

From: Juan Cachito Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Mon, 8 Mar 2004 19:00:15 -0400
Message-ID: <003701c40561$4ecd9900$2501a8c0@dazasoftware.com>

RE: optimizer_index_cost_adj and optimizer_index_cachingIn windows I set DB_FILE_MULTIBLOCK_READ_COUNT to 16 (guy harrison suggestion) which would be the value for MREADTIM in 9i.

And which is the complete name for MREADTIM and SREADTIM please. :)

According to the Metalink note you can even achieve 8.1.7 behavior when you set MREADTIM = 1.2 * SREADTIM and MBRC=8, but I haven't tested this. And finally I haven't heard for a negative feedback till now and this counts as well. But as usual happens in real life also the system stats is not solving all problems.

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Mon Mar 08 2004 - 17:02:38 CST