Re: ORA-01000 max cursors exceeded

On 9 Feb 2005 08:09:36 -0800, azp74_at_hotmail.com wrote:

>We have upped it to 1500!! Someone here came up with the idea of
>upping it to 2 million!
>
>Alex

open_cursors is a *per session* limit.
You may be up to unpleasant surprises if you follow that advice. In fact, 1500 is already way too much. Usually it stops at 500.

--
Sybrand Bakker, Senior Oracle DBA