Re: increase max # of open cursors

From: Brian Peasland <peasland_at_usgs.gov>
Date: Fri, 9 Feb 2001 14:20:05 GMT
Message-ID: <3A83FC95.CCA37181@usgs.gov>

Not necessarily. Increasing OPEN_CURSORS in and of itself will not require you to increase the SGA size. But with more open cursors, you may have the side effect of more contention for SGA resources. So you should monitor your hit ratios and adjust accordingly.

HTH,
Brian

gonagona_at_my-deja.com wrote:
>
> When I increase the max number of open cursors, should I also worry
> about increasing SGA size to accomodate the additional open cursors?
>
> Thanks!
>
> Sent via Deja.com
> http://www.deja.com/

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================

Received on Fri Feb 09 2001 - 08:20:05 CST