Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Location
    Atlanta
    Posts
    134

    Unhappy Unanswered: How many Open_cursors In Oracle-8i

    I am getting ORA-01000 error while a java program run. The initiliazation parameter value for open_curosrs=2048. How can I know how many open cursors are there at any point of time? Any help is appreciated.

    Thanks, Vinnie

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    v$open_cursor
    v$sql_cursor

    investigate why your code is not closing cursors.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  3. #3
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279
    Quote Originally Posted by vkaramched
    open_curosrs=2048.
    IMHO, that's a lot, considering this value is 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
  •