login delay with 9.2.0.5
- From: "Adams, Matthew (GE Consumer & Industrial)" <MATT.ADAMS@xxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 22 Jul 2004 10:48:08 -0400
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@xxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
