Re: oica/oic

You might want to read:

http://www.dbazine.com/jlewis18.shtml

It may explain why your batch job is
taking longer to complete.

Even the "least worst" values for these
parameters can have a negative effect
on SOME of your code. 

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

April 2004 Iceland  http://www.index.is/oracleday.php 
June  2004      UK - Optimising Oracle Seminar
July 2004 USA West Coast, Optimising Oracle Seminar
August 2004 Charlotte NC, Optimising Oracle Seminar
September 2004 USA East Coast, Optimising Oracle Seminar
September2004 UK - Optimising Oracle Seminar

----- Original Message ----- 
From: "Raghu Kota (WBTQ)" <RKota@xxxxxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Monday, April 19, 2004 5:20 PM
Subject: oica/oic



Hi Friends,

Before I used to have default settings of below params, But I changed to =
40(oica) and 90. But my 1/2hour batch job taking 2 1/2hrs extra time =
because of these params!! Is there any particular reason behind it? =
Instead of improving performance its decreased drastically, So how to =
arrive optimal values for these two params? Mine is oracle8174 with =
AIX51.

TIA
Raghu.


----------------------------------------------------------------
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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: