Re: startup takes long time on 10gR2.
- From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
- To: raja4list@xxxxxxxxx
- Date: Fri, 4 Jan 2008 15:47:55 +0100
You might want to try setting event 10046 in your parameter file, startup,
and watch in bdump or udump for growing tracefiles. It will give you an idea
of what's going on.
Stefan
On Jan 4, 2008 3:58 AM, raja rao <raja4list@xxxxxxxxx> 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.
>
> Thanks,
> Raj
>
> ------------------------------
> Never miss a thing. Make Yahoo your
> homepage.<http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs>
>
--
=========================
Stefan P Knecht
Consultant
Infrastructure Managed Services
Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg
Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht@xxxxxxxxxxxx
http://www.trivadis.com
OCP 9i/10g SCSA SCNA
=========================
Other related posts:
