processes and open_cursors?

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 Sun Mar 26 2000 - 18:36:47 CST