Re: Oracle 10g Rel.2 taking longer time when SHUTDOWN IMMEDIATE

On 8/11/06, Kevin Closson <kevinc_at_polyserve.com> wrote:
>
>
> >>>If you must bounce the db what is wrong with shutdown abort?
> You don't look as if this is for a cold backup so who cares that some
> recovery is required?
>
>
> ...there are 600+ connections. might it not be smart to switch logs a
> couple of times before the shutdown abort?

In a word yes. wise , sensible and even a least bad practice. I tend to do

alter system checkpoint;
shutdown abort;

in DBA Created ^H^H^H^H^H unexpected emergency situations.

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l