Re: oica/oic
- From: Mladen Gogala <mladen@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 19 Apr 2004 13:58:37 -0400
On 04/19/2004 01:46:37 PM, Raghu Kota (WBTQ) wrote:
> Changed because too many db file seq reads with nested loops! thinking =
> that these params makes faster access to retrieve table data!!
Nope. The parameters you want to set are "make_queries_run_faster" set to true,
and "bypass_suboptimal_design" also set to true. You should be
on the right Oracle version, set those two parameters, and everything
will run much faster. Alternatively, one could experiment with using
the THC method for tuning the RDBMS performance (THC=Tetrahydrocannabinol)
which is the extension of the "method C" from Cary's book.
--
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
