RE: startup takes long time on 10gR2.

I found it.
 
its becoz, of the databse strutp trigger which is pinning too many objects.


--- On Fri, 9/12/08, Johnson, William L (TEIS) <WLJohnson@xxxxxxxxxxxxxxxxxxx> 
wrote:

From: Johnson, William L (TEIS) <WLJohnson@xxxxxxxxxxxxxxxxxxx>
Subject: RE: startup takes long time on 10gR2.
To: Amir.Hameed@xxxxxxxxx, raja4list@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
Date: Friday, September 12, 2008, 6:35 PM








How many data files are in the database?  It has been a while, but we ran into 
a problem where Oracle was checking on every data file and the startup process 
was dragging while the check occurred. I apologize, but I can’t seem to find my 
notes with the details right now.  Maybe this will help focus where you are 
looking…
 
This was for HP-UX, so it may not be apples-to-apples for Solaris…
Bill
 
 




From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Hameed, Amir
Sent: Friday, September 12, 2008 8:06 AM
To: raja4list@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: 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@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: