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!

check for resumable

447170Aug 12 2005 — edited Jun 19 2007

How can I check to see if a particular session has resumable enabled for it.

I know how to check if statements are suspended but I want to actually find out if a particular session has resumable enabled.

The reason I ask is that I am having

*
ERROR at line 1:
ORA-30044: Resumable cannot be enabled with distributed transactions
ORA-02063: preceding line from CAMDEVF8_FARES
using a database link to connect to a test database and the remote user seems to have resumable session enabled (which it should not have).

I suspect that there is a trigger on the test database whcih enables this so I want to log on to that test database and check my session and see if I have enable session enabled.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 17 2007

Added on Aug 12 2005

#general-database-discussions

4 comments

748 views