select sid, count(*) from V$OPEN_CURSOR group by sid having count(*) > 40 ORDER BY count(*) desc;
The result :
Is used to monitoring ORA-01000 Maximum cursor exceeded.
IT Specialist - Java J2SE J2EE J2ME , HTML, DHTML, XHTML, WML, Javascript, VB , PHP, ASP, XML RPG/400 , CL, SQL/400 OS/400, Windows’98/NT/2000/XP e Linux RedHat 9.0/Fedora/Ubuntu VirtualBox. Yui - Eclipse
Nessun commento:
Posta un commento