Re: startup takes long time on 10gR2.

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_at_yahoo.com> 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_at_trivadis.com
http://www.trivadis.com

OCP 9i/10g SCSA SCNA
=========================

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