Rants and ravings of a semi-autistic developer who has a hard time remembering idiotic nonsense details. Why remember it, when you know where to find it.
Thursday, December 30, 2010
Oracle: what is the cursor count?
select *
from v$sesstat s, v$statname n
where s.statistic# = n.statistic#
and n.name = 'opened cursors current'
and s.sid in (
select sid
from v$session
where machine = '[my machine]'
)
No comments:
Post a Comment