Database Administration (MOSC)

MOSC Banner

ORA-30678 & Shared Pool

edited Apr 7, 2009 4:04AM in Database Administration (MOSC) 4 commentsAnswered
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 ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center