We had an issue affecting one of our production DBs. The middle tier
application for some reason, went crazy spawning processes chewing up
the DBs process parameter. DB started throwing errors indicating max
process exceeded. When I got to the database, I retrieved some of the
SPIDs and all did not have client PIDs. At this point, we only option
was to bounce the DB which ended up resolving the issue of cleaning up
all these process.
My question is could've we awakened the PMON process to do its cleaning
and how? I know there is away using oradebug but I have not tried it
first on any of my play databases to do in this production DB?
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 15 2007 - 08:49:34 CST
