Re: startup takes long time on 10gR2.

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.

Other related posts: