Open Cursors
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Open Cursors

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Posts
    467

    Red face

    Hi,
    I've a problem. My open_cursors in init.ora is 2048.
    If i query (select * from v$sysstat
    where statistic# = '3' gives me a value 3463
    and my query (select count(*) from v$open_cursor gives me a value of 2734. Which one is correct / or what could be wrong ?
    The database is 8.1.5 on Solaris.

    Thanx
    Vinit

  2. #2
    Join Date
    Mar 2000
    Location
    india
    Posts
    54
    from v$open_cursor==> implicit cursors used + distinct explicit cursors opened + dynamic cursors parsed but not closed

    from v$sysstat ===>implicit cursors used + distinct explicit cursors opened + dynamic cursors opened.

    Hope it is clear.
    Raghu

  3. #3
    Join Date
    Oct 2000
    Posts
    467
    Hi,
    Thanks Raghu. But what does the init parameter OPEN_CURSORS indicate and what is the relation between them..!! ?

    Vinit

  4. #4
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Wink what is it


    the parameter OPEN_CURSORS will state the MAXIMUM open cursors allowed in the DB. I forget what the default is but it is fairly low (5 or 10). I remember that we used to get ORA errors until I increased the open_cursors parameter.

    - Magnus

  5. #5
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    In 7.3 , The Default Open_cursor is 50 , I think the value states the number of the cursor opened defaultly after starting the instance .
    Am I right ?

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    it states the maximum number of open cursors per session

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