To details day to day interesting events or incidents that I happen to come across
Thursday, November 22, 2007
Find the highest max open cursors
select max(a.value) as highest_open_cur, p.value as max_open_cur from v$sesstat a, v$statname b, v$parameter p where a.statistic# = b.statistic# and b.name = 'opened cursors current' and p.name= 'open_cursors' group by p.value /
No comments:
Post a Comment