Re: Graceful Death_quiesce

GT Cherer wrote:
>
> dudes-
> is there a preferred method of doing an automatic shutdown of Oracle, at
> say midnite, so that legit jobs/processes finish, but hung or otherwise
> goofy jobs/processes get the ax as appropriate??
> in other words, anyone have experience separating the good guys from the
> bad guys without being there?
> tia
>
> --
> G.T. Jeff Cherer gcherer_at_texas.net
> "You miss 100% of the shots you don't take."
> - Wayne Gretzky, hockeyist, philosopher

That's a little tricky. You can look in the virtual performance views in the data dictionary to track the status of a process. Then, using a dynamic SQL script, kill those processes and do a 'shutdown normal' from SQL*DBA. This makes Oracle wait until everything's done before it quits.

-- 
==============================================================================
Jason Wells                 Tapestry Computing, Inc.       Voice: 314.344.0066
Senior Software Developer   Email:jason.wells_at_tapestry.com   Fax: 314.344.0990
==============================================================================