max cursors

im quite confused with the max cursor setting in "show parameters".

for example i set it at 3000. does this mean that each connection will have 3000 or a shared by different connectioN?

what if 2 applications uses the same user/pass, do they share with the 3000 or they have individual 3000 cursors?

thanks.

Hi, max_cursors specified are per session and not for the entire instance. so, each session/connection to the database will be granted a maximum of 3000 open cursors after which oracle will complain informing you that max cursors have been exceeded.