login delay with 9.2.0.5

From: Adams, Matthew (GE Consumer & Industrial) <MATT.ADAMS_at_GE.COM>
Date: Thu, 22 Jul 2004 10:48:08 -0400
Message-ID: <9E0E38DB4ACFAA4593AD6C4A45C9D5F003C5C8BE@LOUMLVEM01.e2k.ad.ge.com>

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


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

Received on Thu Jul 22 2004 - 10:07:22 CDT