DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: What is the diff in 'opened cursors current' and V$OPEN_CURSOR?

  1. #1
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258

    What is the diff in 'opened cursors current' and V$OPEN_CURSOR?

    We have a problem where our application is hitting 'maximum open cursors exceeded'. I ran the following queries on the database to check what session has the most open cursors:
    select distinct(sid),count(*) from v$open_cursor
    group by sid
    order by count(*)
    /
    and
    select s.sid, max(a.value)
    from v$sesstat a, v$statname b, v$session s
    where a.statistic# = b.statistic#
    and s.sid (+)= a.sid
    and b.name = 'opened cursors current'
    group by s.sid
    order by max(a.value)
    /

    and I found a session in the V$SESSTAT that had a max(value) of 18446744073709551612 (yes, excessive I know!).
    This session/SID didn't appear in the V$OPEN_CURSOR view. Why not? What is the difference between 'opened cursors current' in v$sesstat and V$open_cursor? Thanks. Rgds. Sheryl

  2. #2
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258
    The Oracle version is 10.2.0.4 patch 18. Rgds. Sheryl

  3. #3
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258
    This was a bug fixed in 10.2.0.1 then 'duplicated' in 10.2.0.4.

    Bug 10132807: WRONG NUMBER OF 'OPENED CURSORS CURRENT' IN V$SESSTAT DESPITE USING RDBMS 10.2.0. This is still in development.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width