| 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: Oracle 10g Rel.2 taking longer time when SHUTDOWN IMMEDIATE
Yes, we have experienced similar issues and unfortunately we had to do
SHUTDOWN ABORT, try performing a checkpoint before shutdown immediate,
however it did not help us too much, still we resort to ABORT. I too
want to know if there is a solution/fix for this.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Syed Jaffar Hussain
Sent: Friday, August 11, 2006 11:04 AM
To: _oracle_L_list
Subject: Oracle 10g Rel.2 taking longer time when SHUTDOWN IMMEDIATE
Hello List,
Since migrated from 9i to 10g, we are facing few new issues.
At our premises, we tend to bounce our database at week-end. In 9i, it
was talking few minutes. But, in 10g Re2.10, it is taking more 20
minutes.
When we shutdown immediate, there would be around 600+ inactive
sessions. In 9i, there was not issues with the number of inactive
session, but, in 10g Rel.2, I believe, some internal changes have been
made while killing the inactive session. Thats why, it might be taking
longer time.
I am afraid, if this is the case, in case of emergency, we need to wait
20+ minutes to bring down the database. I dont want to opt for 'shutdown
abort' option.
Is anyone had/having the same issue with 'shutdown immediate' in Oracle
10g Rel.2?
--
Best Regards,
Syed Jaffar Hussain
8i,9i & 10g OCP DBA
Banque Saudi Fransi,
Saudi Arabia
I blog at :http://jaffardba.blogspot.com/ http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
 |
 |