Re: startup takes long time on 10gR2.

From: Prasad <p4cldba_at_gmail.com>
Date: Thu, 11 Sep 2008 20:38:55 -0700
Message-ID: <666b99c70809112038u3280092ake90ec6aa1ed28b7c@mail.gmail.com>


how about checking the datafiles placements. probably it will be a good way to start debugging is by starting with making datafiles offline for some non-system tablespaces and see if it helps.

On Thu, Sep 11, 2008 at 8:26 PM, raja rao <raja4list_at_yahoo.com> wrote:

> One of our test instances, the startup process is taking more time.
>
>
> sga is ~2gb.
>
>
> Total System Global Area 2130706432 bytes
> Fixed Size 2031448 bytes
> Variable Size 1140850856 bytes
> Database Buffers 973078528 bytes
> Redo Buffers 14745600 bytes
>
> especially, the open phase takes long time.(around 10 mins)
> instance allocation and mount phase are quick.
>
>
> Can someone help me, how to start research and reduce the time.
>
> Thanks,
> Raj
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 11 2008 - 22:38:55 CDT

Original text of this message