# of open cursors

[solarsys]

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

[julian]

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.

[solarsys]

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