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

Mark,

It may not be waise.
Because, killing more than 600+ connections will might take the same time and apart from that, all these connections coming from Oracle Application Server using JDBC think connectivity. Even after killing session, it remains as defunc and killed sessions. That makes other problems.

Jaffar

On 8/11/06, Powell, Mark D <mark.powell_at_eds.com> wrote:
> Have you tried killing all connected sessions immediately prior to
> issuing the shutdown immediate?
>
> HTH -- Mark D Powell --
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Singh, Ranjay
> Sent: Friday, August 11, 2006 11:08 AM
> To: sjaffarhussain_at_gmail.com; _oracle_L_list
> Subject: 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
> ------------------------------------------------------------------------
> ----------
> "Winners don't do different things. They do things differently."
> --
> http://www.freelists.org/webpage/oracle-l
> ====================
> This email/fax message is for the sole use of the intended
> recipient(s) and may contain confidential and privileged information.
> Any unauthorized review, use, disclosure or distribution of this
> email/fax is prohibited. If you are not the intended recipient, please
> destroy all paper and electronic copies of the original message.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
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
----------------------------------------------------------------------------------
"Winners don't do different things. They do things differently."
--
http://www.freelists.org/webpage/oracle-l