Re: How To Improve Connection Times?

From: Mladen Gogala <mgogala_at_adelphia.net>
Date: Mon, 27 May 2002 03:38:22 -0400
Message-ID: <acsnpe$iuva9$1@ID-82084.news.dfncis.de>

On Sun, 26 May 2002 17:34:51 -0400, Sybrand Bakker wrote:

> Java pool is outrageous when not using Java (decrease it to 1M) Buffer
> cache is outrageous for this size of database. If you think you really
> need this to guarantee performance, I'd better start tuning my statements
> *now*.

His problem is connecting to the database. Would you advise him to use bitmap indexes while doing that? What exactly should he tune in his SQL statements in order to connect faster?

> Most likely you have assigned so much resources to Oracle you are
> *causing* excessive paging.

Here I do agree with you. I would, however, like to see an output from sar, iostat or vmstat.

-- 
Mladen Gogala
Za Feral Spremni!

Received on Mon May 27 2002 - 02:38:22 CDT