Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cursors in Autonomous Transaction Processing

2908084Jul 22 2019 — edited Jul 23 2019

Hi,

What about cursors in ATP? Because we can not set the “open_cursors” parameter with “ALTER SYSTEM SET open_cursors = ### SCOPE=BOTH;” maximum, what is the default value for cursors? Can we use of them? What will happen if there are a lot of them? I’m aware of a known issue of “ORA-01000: maximum open cursors exceeded”.

Thanks in advance

This post has been answered by Billy Verreynne on Jul 23 2019

Jump to Answer

Added on Jul 22 2019

#cursor, #general-database-discussions

10 comments

1,585 views