SMON - Killed process

Hi,

        We run Oracle 7.2.3 on HP-UX 10.20

        Each night, we run a script which kills running sessions, if any, on HP-level. After that an shutdown immediate is performed an backup starts. Everything worked fairly well.

        Last night, a hugh Oracle procedure was running and get killed by the script. However, about 8 hours later the immediate shutdown was not yet performed. As far as I could tell, it was waiting for the ORA_SMON process, which was running at 90% cpu. Is SMON cleaning up the killed procedure ???

        Best solution I figure would be killing the ORACLE-session, rather than killing the process on HP-level. Would that prevent events similar to last night ? But how to do it ???

        Any hints for this constantly learning - I only learned about Oracle about 2 years ago - they're all looking at me - junior would be grately appreciated, as ever !!!

        Greets,

Kirsten
Living : Near Antwerp - Belgium
Working : Near Breda - Netherlands Received on Fri Jun 30 2000 - 05:10:02 CDT