Re: startup takes long time on 10gR2.

you might try setting fast_start_mttr_target = 200 and check if it helps.

On Jan 3, 2008 7:17 PM, Peter McLarty <peter.mclarty_at_pacificdbms.com.au> wrote:

> Hi
>
> It sounds like it may have a bit of redo to apply. You have said it is
> taking more time, more than what production, more than last month.
>
> Depending on what you are referring to you need to investigate what has
> changed in your environment.
>
> Cheers
>
> Peter
>
>
> On Thu, 2008-01-03 at 18:58 -0800, raja rao 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
>
> ------------------------------
>
> Never miss a thing. Make Yahoo your homepage.<http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs>
>
>

--
http://www.freelists.org/webpage/oracle-l