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... [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> > <david.m.nguye cc: > [EMAIL PROTECTED]> Subject: Database shutdown > Sent by: > [EMAIL PROTECTED] > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
