RE: startup takes long time on 10gR2.

I am assuming that you are on Solaris 8? Is this true? If you truss you may find that the process starting the database is waiting on "shmat" call.

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of raja rao

	Sent: Thursday, September 11, 2008 11:27 PM
	To: oracle-l_at_freelists.org
	Subject: startup takes long time on 10gR2.
	
	

	One of our test instances, the startup process is taking more

        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

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