Path: news.easynews.com!easynews!feed2.onemain.com!feed1.onemain.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!fu-berlin.de!uni-berlin.de!12.250.76.45!not-for-mail
From: Bouncedave2702@hotmail.com (The Electric Frog)
Newsgroups: comp.databases.oracle.server
Subject: Re: login delay
Date: Sat, 15 Dec 2001 17:18:17 GMT
Lines: 13
Message-ID: <3c1b858f.7812623@news.cis.dfn.de>
References: <h2JS7.309176$5A3.119308114@news1.rdc2.pa.home.com>
NNTP-Posting-Host: 12.250.76.45
X-Trace: fu-berlin.de 1008436644 15184234 12.250.76.45 (16 [99427])
X-Newsreader: Forte Free Agent 1.21/32.243
Xref: easynews comp.databases.oracle.server:128129
X-Received-Date: Sat, 15 Dec 2001 10:18:24 MST (news.easynews.com)

On Sat, 15 Dec 2001 14:24:13 GMT, "Tom Blakeley"
<tom-blakeley@home.com> wrote:

>When I login to oracle (7.3.2.3) vi sqlplus or any other means, I experience
>a significant delay before getting in. Any thoughts?
>
>
>

Do you have a login.sql or a glogin.sql ??? it might be worth
checking for blocking locks, and perhaps having the database 
in full sql_trace=true mode and monitor the v$session_wait