Integer

50

Can be set for an individual connection or for PUBLIC. You must have the SET ANY SYSTEM OPTION system privilege to set this for PUBLIC or any connection. Takes effect immediately.

This resource governor allows a DBA to limit the number of cursors per connection that a user can use. If an operation would exceed the limit for a connection, an error is generated, indicating that the governor for the resource has been exceeded.

If a connection executes a stored procedure, that procedure is executed under the privileges of the procedure owner. However, the resources used by the procedure are assigned to the current connection.

You can remove resource limits by setting the option to 0 (zero).

• Tip: Use resource governors
• max_cursor_count connection property