Re: oica/oic

  • From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 19 Apr 2004 17:31:54 +0100

You might want to read:

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. 


Jonathan Lewis

The Co-operative Oracle Users' FAQ

April 2004 Iceland 
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 =


Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at
  • References:

Other related posts: