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!

How to check cursor stats during Runtime

AnkitVSep 23 2011 — edited Sep 24 2011

Hi
I have a stored procedure running in which there is a cursor which fetches around 1500000 records and then query another table using the fetched record values.
I cannot modify the procedure as its on production.
I want to know which cursor record is currently being processed by the procedure, and how many are still remaining ?
I have cursor name.
Is there some dynamic view to check cursor stats at runtime ??

thanks.

Edited by: AnkitV on Sep 23, 2011 7:27 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 22 2011

Added on Sep 23 2011

#general-database-discussions

14 comments

1,373 views