Re: processes and open_cursors?

1. Processes is roughly the number of users + 10
2. open_cursors is a per user limit, no relationship to processes. 200 seems to be a minimum.
3. cursors should be closed but NOT released. If you leave them open, you will eventually run out of cursors. Powerbuilder automatically closes AND releases cursors, causing reparses to occur very frequently, which is BAD. You'll probably need to set the SqlCache dbParm parameter to at least 50.

Hth,
Sybrand Bakker, Oracle DBA

David Spaisman <davedba_at_intercall.net> wrote in message news:38DED790.A57635F0_at_intercall.net...
> Hello:
>
> I will be supporting an application(Powerbuilder) that is being
> converted from microsoft sql server 6.5 to Oracle 8.0.5 or Oracle 8i.
>
> One of the items I have been thinking about is how to relate some items
> that are included in the initialization file.
> One item is processes and the other item is open_cursors.
>
> My initial guess is proceses is related to the number of concurrent
> users expected. The open_cursors is probably based on that as well. I
> have read about whether or nor the cursors should be closed at the end
> of a transaction or not. I am not sure which way is better.
>
> 1) Can any one tell me how do I determine the number of 'processes' to
> use?
>
> 2) How do I relate processes to open_cursors, if at all?
>
> 3) I believe the nature of he application's transaction probably should
> be used to decide if cursors should be left open or shut? Which
> parameter should I use? What criteria should I use to determine whether
> cursors should be left open or closed?
>
>
> 4) How do I relate the number of proceses to be set to the
> open_cursors?
>
> Any information that can be furnished will be greatly appreciated
>
>
> THank you.
>
> David Spaisman
>
>
>
Received on Mon Mar 27 2000 - 00:01:08 CST