Re: startup takes long time on 10gR2.

From: raja rao <raja4list_at_yahoo.com>
Date: Thu, 11 Sep 2008 20:41:18 -0700 (PDT)
Message-ID: <58586.80114.qm@web56204.mail.re3.yahoo.com>

eventhough the db is big around 1 TB, all datafiles are in single mountpoint.
 

but i am really looking to start debugging (dont knwo if oradebug or someother utility will help what is happening after mount and before open).

• On Fri, 9/12/08, Prasad <p4cldba_at_gmail.com> wrote:

From: Prasad <p4cldba_at_gmail.com>
Subject: Re: startup takes long time on 10gR2. To: raja4list_at_yahoo.com
Cc: oracle-l_at_freelists.org
Date: Friday, September 12, 2008, 9:08 AM

how about checking the datafiles placements.  probably it will be a good way to start debugging is by starting with making datafiles offline for some non-system tablespaces and see if it helps.

On Thu, Sep 11, 2008 at 8:26 PM, 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

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

Received on Thu Sep 11 2008 - 22:41:18 CDT