| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Adams, Matthew (GE
Consumer & Industrial)
Sent: Thursday, July 22, 2004 3:58 PM
To: oracle-l_at_freelists.org
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.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mark W. Farnham
Sent: Thursday, July 22, 2004 3:26 PM
To: oracle-l_at_freelists.org
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Paul Baumgartel
Sent: Thursday, July 22, 2004 2:53 PM
To: oracle-l_at_freelists.org
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_at_GE.COM>
wrote:
> This last weekend we upgraded an Oracle Apps=3D20
> instance from 8.1.7 to 9.2.0.5.0.
>
>
>
>
>
>
-- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 Fri Jul 23 2004 - 11:31:21 CDT
 |
 |