startup takes long time on 10gR2.
Date: Thu, 3 Jan 2008 18:58:01 -0800 (PST)
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.
http://www.freelists.org/webpage/oracle-l Received on Thu Jan 03 2008 - 20:58:01 CST