SQL & PL/SQL

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!

Identify and close all Id Cursor of session

muttleychessOct 20 2017 — edited Nov 7 2017

Please , is possible knowing the session (.sid and serial#) identify all ID cursor opened with dbms_sql.open and close all ?

tia

using

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

PL/SQL Release 11.2.0.4.0 - Production

CORE 11.2.0.4.0 Production

TNS for Linux: Version 11.2.0.4.0 - Production

NLSRTL Version 11.2.0.4.0 - Production

This post has been answered by unknown-7404 on Oct 21 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 18 2017

Added on Oct 20 2017

8 comments

2,473 views