Mladen, Iam trying to change 'those' parameters!! Thank you :) -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] Sent: Monday, April 19, 2004 1:59 PM To: oracle-l@xxxxxxxxxxxxx Subject: Re: oica/oic On 04/19/2004 01:46:37 PM, Raghu Kota (WBTQ) wrote: > Changed because too many db file seq reads with nested loops! thinking = =3D > 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=20 will run much faster. Alternatively, one could experiment with using the THC method for tuning the RDBMS performance = (THC=3DTetrahydrocannabinol) which is the extension of the "method C" from Cary's book. --=20 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------