Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 30089 invoked from network); 13 Sep 2008 22:45:25 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by air964.startdedicated.com with SMTP; 13 Sep 2008 22:45:25 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4ED7B9869D2; Sat, 13 Sep 2008 23:45:25 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 06214-04; Sat, 13 Sep 2008 23:45:25 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B8AE29869F1; Sat, 13 Sep 2008 23:45:24 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Sat, 13 Sep 2008 23:43:26 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7937398694E for ; Sat, 13 Sep 2008 23:43:26 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05864-04 for ; Sat, 13 Sep 2008 23:43:26 -0400 (EDT) Received: from web56205.mail.re3.yahoo.com (web56205.mail.re3.yahoo.com [216.252.110.214]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id F1381986940 for ; Sat, 13 Sep 2008 23:43:25 -0400 (EDT) Received: (qmail 90306 invoked by uid 60001); 14 Sep 2008 03:43:24 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Message-ID; b=kEAmySypVjV67ZU8fZWNA1GrXwnmeKd08adnWJgg3k6q9u7uh26+f+uV1h8TnsLNJVtw2+lvmyhP45wEbdj2YDwKqLYTTIKQEzKBM+YSmjgGGGBBh2zt9AHDepGVJU/Z4QOUFnsaWZI63WTXGJK+DUQakKaljxumBOk7NjlwxqA=; X-YMail-OSG: Oh.hOTwVM1kP42MJciS4of2pMBNDcQ5D3eHlqP1U_WS3caUwuL2mAR0NEtVLTZICzh1y7TaRI6O4TjP.Vp1R2oycYLKNhh.rgIgthyqIew65oJPM_RPafriWVoBvn6s- Received: from [63.99.228.190] by web56205.mail.re3.yahoo.com via HTTP; Sat, 13 Sep 2008 20:43:24 PDT Date: Sat, 13 Sep 2008 20:43:24 -0700 (PDT) From: raja rao Subject: RE: startup takes long time on 10gR2. To: Amir.Hameed@xerox.com, oracle-l@freelists.org, WLJohnson@tycoelectronics.com In-Reply-To: <70C6CD0D975AFC43859A976DFD98C2FE0E047FAC@us194mx20.tycoelectronics.net> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-544870303-1221363804=:89300" Message-ID: <785314.89300.qm@web56205.mail.re3.yahoo.com> X-archive-position: 10819 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: raja4list@yahoo.com Precedence: normal Reply-to: raja4list@yahoo.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain --0-544870303-1221363804=:89300 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable I found it. =A0 its becoz, of the databse strutp trigger which is pinning too many objects. --- On Fri, 9/12/08, Johnson, William L (TEIS) wrote: From: Johnson, William L (TEIS) Subject: RE: startup takes long time on 10gR2. To: Amir.Hameed@xerox.com, raja4list@yahoo.com, oracle-l@freelists.org Date: Friday, September 12, 2008, 6:35 PM How many data files are in the database? =A0It has been a while, but we ran= into a problem where Oracle was checking on every data file and the startu= p process was dragging while the check occurred. I apologize, but I can=92t= seem to find my notes with the details right now. =A0Maybe this will help = focus where you are looking=85 =A0 This was for HP-UX, so it may not be apples-to-apples for Solaris=85 Bill =A0 =A0 From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] = On Behalf Of Hameed, Amir Sent: Friday, September 12, 2008 8:06 AM To: raja4list@yahoo.com; oracle-l@freelists.org Subject: RE: startup takes long time on 10gR2. =A0 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@freelists.org [mailto:oracle-l-bounce@freelists.org] = On Behalf Of raja rao Sent: Thursday, September 11, 2008 11:27 PM To: oracle-l@freelists.org Subject: startup takes long time on 10gR2. One of our test instances, the startup process is taking more time. =A0 =A0 sga is ~2gb. =A0 =A0 Total System Global Area 2130706432 bytes Fixed Size=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 2031448 bytes Variable Size=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 1140850856 bytes Database Buffers=A0=A0=A0=A0=A0=A0=A0=A0=A0 973078528 bytes Redo Buffers=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 14745600 bytes =A0 especially, the open phase=A0takes long time.(around 10 mins) instance allocation and mount phase are quick. =A0 =A0 Can someone help me, how to start research and reduce the time. =A0 Thanks, Raj =A0=0A=0A=0A --0-544870303-1221363804=:89300 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable
I found it.
 
its becoz, of the databse strutp trigger which is pinning too many obj= ects.


--- On Fri, 9/12/08, Johnson, William L (TEIS) <WLJoh= nson@tycoelectronics.com> wrote:
From: Johnson, William L (TEIS) <WLJohnson@tycoele= ctronics.com>
Subject: RE: startup takes long time on 10gR2.
To: A= mir.Hameed@xerox.com, raja4list@yahoo.com, oracle-l@freelists.org
Date: = Friday, September 12, 2008, 6:35 PM

How many data files a= re in the database?  It has been a while, but we ran into a problem wh= ere Oracle was checking on every data file and the startup process was drag= ging while the check occurred. I apologize, but I can=92t seem to find my n= otes with the details right now.  Maybe this will help focus where you= are looking=85

 <= /DIV>

This was for HP-UX, s= o it may not be apples-to-apples for Solaris=85

Bill

 <= /DIV>

 <= /DIV>

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] = On Behalf Of Hameed, AmirSent: Friday, September 1= 2, 2008 8:06 AM
To: raja= 4list@yahoo.com; oracle-l@freelists.org
Subject: RE: startup takes long time on 10gR2.

 

I a= m assuming that you are on Solaris 8? Is this true? If you truss you may fi= nd that the process starting the database is waiting on "shmat" call.

From: oracle-l-bounce@freelists.org [mailto:o= racle-l-bounce@freelists.org] On Behal= f Of raja rao
Sent: Thursday, September 11, 2008 11:27 PM
To: oracle-l@freelists.org
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&n= bsp;            = ;     2031448 bytes
Variable Size   &= nbsp;        1140850856 bytes
Databas= e Buffers          973078528 b= ytes
Redo Buffers         &= nbsp;     14745600 bytes

 

especially, the open phase takes long time.(around 1= 0 mins)

instance allocation and mount phase are quick.

 

 

Can someone help me, how to start research and reduce the= time.

 

Thanks,

Raj

 


=0A=0A --0-544870303-1221363804=:89300-- -- http://www.freelists.org/webpage/oracle-l