Re: startup takes long time on 10gR2.

From: Asif Momen <>
Date: Fri, 4 Jan 2008 03:46:50 -0800 (PST)
Message-ID: <>

Hi Rao,

How are you shut down your database? Do you use "shutdown abort" ??


Asif Momen

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.    


Never miss a thing. Make Yahoo your homepage.        

Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
Received on Fri Jan 04 2008 - 05:46:50 CST

Original text of this message