Re: oica/oic

From: Mladen Gogala <mladen_at_wangtrading.com>
Date: Mon, 19 Apr 2004 13:58:37 -0400
Message-ID: <20040419175837.GC17794@mladen.wangtrading.com>

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_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 Apr 19 2004 - 12:55:31 CDT