How to finding Maximum SESSION_CACHED_CURSORS in useselect max(value) from v$sesstat natural join v$statname where name = ‘session cursor cache count’ ; Select amount,SESSION_CACHED_CURSORS*30+30 Cached_Cursors_Rounded from (select trunc(value/30) SESSION_CACHED_CURSORS,count(*) Amount from V$sesstat natural join v$statname where name = ‘session cursor cache count’ group by trunc(value/30) order by 1); AMOUNT CACHED_CURSORS_ROUNDED ———- ———————- 2
