RE: startup takes long time on 10gR2.
- From: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>
- To: <raja4list@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 12 Sep 2008 08:05:33 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of raja rao
Sent: Thursday, September 11, 2008 11:27 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: startup takes long time on 10gR2.
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
Other related posts:
