Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: login delay
On Sat, 15 Dec 2001 14:24:13 GMT, "Tom Blakeley"
<tom-blakeley_at_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 Received on Sat Dec 15 2001 - 11:18:17 CST