1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Is there some dynamic view to check cursor stats at runtime ??

Discussion in 'General' started by Haba4568, Jun 30, 2018.

  1. Haba4568

    Haba4568 Newly Initiated

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    30
    Location:
    Haba4568
    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 ?
    please provide guidance on how to check the cursor stats at runtime. I want to check upto which record the cursor has been fetched and how many are still remaining.
    I have cursor name.
    Is there some dynamic view to check cursor stats at runtime ??

    thanks.
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,615
    Likes Received:
    364
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    No such view exists. Cursors are memory structures and don't have such 'statistics' recorded. Except for curiosity why do you 'need' that information?