ORA-30678 & Shared Pool
Couple of days back we had an error, ORA-30678 too many open connections caused by a stored procedure which had invoked UTL_MAIL.SEND, about 30,000+ times in our oracle 10g database on Solaris 9 platform. Later in the day we started having perofrmance (mainly high CPU) issues. We could not pin point the root cause of performance issue. One of our colleagues did a shared pool flush and we have seen a dramatic improvement. Is there a corealtion to ORA-30678 to degraged performance and finally sharepool flush which seem to have helped ?
0