Oracle Database Discussions

Hello Guys,

I need clarification on the following, if the open_cursors value has reached will Oracle rollback the cursors that it has opened?
In other words I'll explain the situation in my case: -

I have an application (to be logged in as 'system' user) with which you can create Oracle user accounts, relating tablespaces, data+index files, GRANTs, ROLES etc hence opens cursors.

If the open_cursors value is set to a low number (for testing purposes) and I try to create a user account, I'm getting an error saying "<username> is logged in cannot be removed".

Sometimes I do get the standard ORA-01000 error of exceeding max open cursors which I understand is fine.

But why the error "username is logged in cannot be removed"? Is it because Oracle is trying to rollback on the operation of creating a user??

I think this is the case because the user is then connected to the db and its tables are created under its schema.

I need a confirmation on this. Whether the cursors/operations are rolled back if maximum open_cursors are reached.


Thanks in advance guys.