RE: 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 15:57:35 -0400
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 //www.freelists.org/archives/oracle-l/
> FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
