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

Thread: # of open cursors

  1. #1
    Join Date
    Nov 2001
    Posts
    16
    Hi,

    I ran query

    select sum(users_opening) from v$sqlarea;

    sometimes the result is not a whole number. eg. one time I got a result of 1982.5. what's the .5 mean? Can user open
    0.5 or 1.5 cursors? I am getting lost here.

    Thanks

    James

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    I think the correct query is sum(250*users_opening). I assume you are trying to compute the user_size? The result is in bytes.




  3. #3
    Join Date
    Nov 2001
    Posts
    16
    Julian,

    You'r right, I do use sum(250*users_opening) to get the size.
    But I just curious to see what users_opening will give me, as
    I understand it's the #of opening cursors. Please correct me
    if I am not right.

    Thanks

    James

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