Killing pmon service - does Oracle backout?

Hi!!,

        I recently hosed our test system and could not get into any utility applications (SQLPLUS, SVRMGRL, ..) and I needed to bring down some hung instances. (The system is Sun Solaris release 2.6 using Oracle 8.1.6) I ended up canceling the PMON task of the various instances to get them to come down. They all terminated and I was sure that I was going to have to do a recovery to get them to come back up. To my surprise all the instances came up fine after getting everything functionable.

        Does anyone know what happens when you cancel PMON that allowed this to happen? Did SMON clean things up before the instances terminated? I hope I don't have a false sense of comfort!?         

        Thanks in advance for your input!!!

Tony Barker
DBA - State of Indiana
tbarker_at_doit.state.in.us (317)232-0719 Received on Tue Jan 16 2001 - 08:31:11 CST