Re: Large SGA - performance problems

From: Dennis R. Otero <dennis.otero-1_at_edams.ksc.nasa.gov>
Date: 1997/01/03
Message-ID: <32CD0CC2.201B@edams.ksc.nasa.gov>#1/1

Erlend Dyrnes wrote:
> snip
> Every now and then a user generate a table scan (one way or another).
> This table scan tends to "hang" the database for a while. The database
> process uses ~100% CPU, and nothing else is allowed to happen on the
> database during the table scan. Not even a sqlplus session login. The
> hangs may last from 5 seconds up to over 1 minute. As of now we can
> cope, but as we increase number of concurrent users, I'am afraid the
> problem will be a nightmare.
> snip

Hi Eriend
You mentioned a table scan, perhaps you need to look at your sort statistics, if your sorts are going to disk you should enlarge your sort_area init parameters. I hope this helps

Dennis Received on Fri Jan 03 1997 - 00:00:00 CST