RE: login delay with 9.2.0.5

From: Loughmiller, Greg <greg.loughmiller_at_cingular.com>
Date: Thu, 22 Jul 2004 15:08:57 -0400
Message-ID: <5164A49467308C45AD50661F8CFDC34319200EAB@s30342g004004.wdc.cingular.net>

Matt,
Did you apply any of the one-off patches to the oracle apps instance? We are in the process of upgrading the 11i instance; and have a list of patches that Oracle has recommended.
Thanks!
Greg

-----Original Message-----

From: Adams, Matthew (GE Consumer & Industrial) [mailto:MATT.ADAMS_at_GE.COM] Sent: Thursday, July 22, 2004 10:48 AM
To: oracle-l_at_freelists.org
Subject: login delay with 9.2.0.5

This last weekend we upgraded an Oracle Apps=20 instance from 8.1.7 to 9.2.0.5.0.

Now sqlplus logins can take as long as 30 seconds=20 and we're seeing peformance degradation pretty much=20 across the board.

It's a sun 6800 with 20 Cpus and 40G of ram. =20 Machine does not appear to be bottlenecked on hardware at any point. Don't see any obvious problems anywhere.

I can't set event 10046 for the whole instance, but I would=20 very much like to know why logins are taking so long.

Any suggestions?

Matt

Matt Adams - GE Appliances - matt.adams_at_appl.ge.com That's what's cool about working with computers.=20 They don't argue, they remember everything and they=20

don't drink all your beer.    - Paul Leary, 1991


----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.

--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Thu Jul 22 2004 - 15:48:21 CDT