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?