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@xxxxxxxxxxxxxxxxxx> 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> > >