-
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
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|