RE: login delay with 9.2.0.5

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

Hmm. Wild shot in the dark -- did formerly local bequeaths inadvertantly
become out and back sessions (possibly to a listener log in an inconvenient
and unmanaged location?

Otherwise the other poster's suggestions on truss make a great deal of sense
as the next thing to try.

Either way, knowing how long before you get to the place where you try to
turn the key in the lock on Oracle's front door will tell you where to look
for a problem to solve.

Again, good luck.

mwf

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Adams, Matthew (GE
Consumer & Industrial)
Sent: Thursday, July 22, 2004 3:58 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: login delay with 9.2.0.5


The listener log file does not come into play, as these=20
are local connections on the DB server.


----
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


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Mark W. Farnham
Sent: Thursday, July 22, 2004 3:26 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: login delay with 9.2.0.5


With delays this long (30 seconds) you should be able to trivially =
partition
the delay between sqlnet recognition and oracle rdbms login processing =
by
tailing the listener log file. I'm pretty sure it still buffer flushes
plenty frequently enough to see if a significant portion of your login =
chain
time is before the rdbms is even involved.

This observation won't solve your problem, but it will help tell you =
where
to look for it.

Btw you may want to see if you've developed a bottleneck on appending to =
the
listener log file. I don't know whether clutter and delays seeking to =
the
end of long log files to write are really a problem any more, since long =
ago
when they were I adopted a practice of having dated subdirectories and
cycling logs. Having adopted that practice (which is well worth the near
zero cost of having it just for organizational purposes), I no longer =
get
data whether those old problems continue to exist.

good luck

mwf

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Paul Baumgartel
Sent: Thursday, July 22, 2004 2:53 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: login delay with 9.2.0.5


You can't trace the whole instance, but you can create a login trigger
that starts tracing using DBMS_SUPPORT (note:  this package is not
installed by default; log in as SYS and run
$ORACLE_HOME/rdbms/admin/dbmssupp.sql, then grant execute on
DBMS_SUPPORT either to PUBLIC or one or more individual users first):

create or replace trigger trace_all
after logon on schema
begin
  DBMS_SUPPORT.START_TRACE(waits=3D>true,binds=3D>false);
end;
/

Do this for one or two users, then TKPROF (with WAITS=3DYES) the trace
files and inspect the output.  Then disable the trigger.  I do this all
the time and it works very well.

Of course, if the delay occurs before the trigger fires, this won't
help you!

PB
--- "Adams, Matthew (GE Consumer & Industrial)" <MATT.ADAMS@xxxxxx>
wrote:
> This last weekend we upgraded an Oracle Apps=3D20
> instance from 8.1.7 to 9.2.0.5.0.
>
> Now sqlplus logins can take as long as 30 seconds=3D20
> and we're seeing peformance degradation pretty much=3D20
> across the board.
>
> It's a sun 6800 with 20 Cpus and 40G of ram. =3D20
> 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=3D20
> 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.=3D20
> They don't argue,  they remember everything and they=3D20
> 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 http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>





__________________________________
Do you Yahoo!?
Vote for the stars of Yahoo!'s next ad campaign!
http://advision.webevents.yahoo.com/yahoo/votelifeengine/
----------------------------------------------------------------
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 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@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: