Re: Database shutdown

Hi,

Set event 10400 to turn on system state dumps for shutdown debugging to see what is happening. I guess, SMON is cleaning up your temporary segments.

regards...

Brian_P_MacLean_at_efunds.com wrote:

> Try "shutdown abort", takes about 2 seconds...works for me (ROFLOL)
>
> If you are doing a "shutdown" or "shutdown normal" (same things) then
> Oracle waits for all sessions to disconnect, flushes everything, and
> checkpoints the database, could be a long wait.
>
> If you are doing a "shutdown immediate" then all sessions will be
> terminated, uncommitted transactions rolled back, the buffer cache needs to
> be flushed, and the database will be checkpointed. Can take awhile if your
> checkpoints are spaced far apart.
>
> If you do a "shutdown abort" be aware that cache recovery must be done on
> instance startup so startup may take a few minutes, again depending how
> long your checkpoints are spaced.
>
> (Trying to remember all of the above from memory, and I'm getting old. So
> if any of it is incorrect, remember, the consulting fee cost $0.00)
>
> Brian P. MacLean
> Oracle DBA, OCP8i
>
>
> "Nguyen, David
> M" To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> <david.m.nguye cc:
> n_at_xo.com> Subject: Database shutdown
> Sent by:
> root_at_fatcity.c
> om
>
>
> 04/16/02 09:03
> AM
> Please respond
> to ORACLE-L
>
>
>
> Does any know why it takes too long (about 40 minutes) to shutdown oracle
> database? I am running oracle8.0.5 on solari5.6. It usually just takes me
> few minutes to shutdown.
>
> Thanks,
> David
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Nguyen, David M
> INET: david.m.nguyen_at_xo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Brian_P_MacLean_at_eFunds.Com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

--
Danisment Gazi Unal
http://www.unal-bilisim.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Danisment Gazi Unal
  INET: dunal_at_unal-bilisim.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).