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!

How to practice with message? -> Metrics "Current Open Cursors Count" is at 14556

Discussion in 'Server Administration and Options' started by kachar, Aug 4, 2014.

  1. kachar

    kachar Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Thailand
    There are warning message from database server version 11g
    #Metrics "Current Open Cursors Count" is at 14556.

    How to practice with message?
    if who are know Please advise to me.

    Thank you. ;);)

    L.Kachar
     
  2. ocprep

    ocprep Forum Advisor

    Messages:
    277
    Likes Received:
    76
    Trophy Points:
    410
    Location:
    Orlando, Florida
    I'm not really sure what you mean by 'practice with message'. I will say that's a significant number of open cursors. If I saw that on anything but a very large and active database, I would assume there might be one or more PL/SQL blocks that were opening cursors but not closing them properly.
     
  3. krasnoslobodtsev_si

    krasnoslobodtsev_si Forum Genius

    Messages:
    626
    Likes Received:
    129
    Trophy Points:
    810
    Location:
    Russian Federation
    Hi.
    For example :
    Code (SQL):


    SHOW parameters open_cursors;

    SELECT
       MAX(a.VALUE) AS open_cur,
       p.VALUE      AS max_open_cur
    FROM
       v$sesstat a,
       v$statname b,
       v$parameter p
    WHERE
       a.statistic# = b.statistic#
    AND
       b.name = 'opened cursors current'
    AND
       p.name= 'open_cursors'
    GROUP BY p.VALUE;

     

    Open Cursors