Wednesday, May 19, 2004
Oracle open cursors
SELECT sql_text, COUNT(sql_text)
FROM v$open_cursor
GROUP BY sql_text
ORDER BY COUNT(sql_text) DESC;
FROM v$open_cursor
GROUP BY sql_text
ORDER BY COUNT(sql_text) DESC;