| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: shutdown abort to move data files
David,
I believe I'd start asking why does a "shutdown immediate" take so = long? There are a number of answers, some of which you could fix, = others that need "indoctrination". First on the list is how big is the = SGA? If your DB_BLOCK_BUFFERS (since your on 8i) are REALLY huge then = that could be one of the slowing factors. Consider reducing them. Next = is how many end user sessions are busy at the time. Remember an = immediate will wait till their current transaction is finished before = shutting down. Can you get the owners of these sessions to agree to a = date/time when you'll do maintenance. Third are the number of dead or = sniped sessions in your database. This one really torques my jaws. End = users who start an application that uses the database & then walk away = believing that it "will take care of itself". Consider setting =
resource_limit=3Dtrue & setting up profiles with "reasonable" idle time = periods. Most of my end users have a 30 minute idle timeout, but I did = have one that was set to 1 minute because he was a perpetual offender. =OH, then there's my personal favorite, the end user who starts his/her = application and then powers their workstation down. Windoze is not = always graceful on this count. All of these will cause an immediate to = slow down. Fix the problem, not the symptom. Crashing the database may = well cause more harm, read that as recovery time, than good.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-----Original Message-----
From: Nguyen, David M [mailto:david.m.nguyen_at_xo.com]
Sent: Thursday, July 08, 2004 11:48 AM
To: oracle-l_at_freelists.org
Subject: shutdown abort to move data files
I need to shutdown oracle8i database to move data file to another disk but it takes about 40 minutes to shutdown immediate. Can I go ahead to issue "shutdown abort" then move data file? Does it hurt anything? =20
Thanks,
David
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |