Re: SGA and PGA

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: 27 Oct 2006 15:01:11 -0700
Message-ID: <1161986470.937236.323640@e3g2000cwe.googlegroups.com>

joel garry wrote:
> optimizer_index_caching and optimizer_index_cost_adj sometimes don't
> have good default values, too, depending on the type of application.

I'd say that optimizer_mode probably can make even greater role if it is left as default and has inappropriate value for particular app :)

Anyway I think Christian Antognini has written a nice article about that - check CBO configuration roadmap at http://www.trivadis.com/Images/CBOConfigurationRoadmap_tcm17-14317.pdf

Gints Plivna
http://www.gplivna.eu Received on Fri Oct 27 2006 - 17:01:11 CDT