Re: What causes a connection attempt via sqlplus to hang?

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Wed, 13 Jul 2005 15:05:18 GMT
Message-ID: <Xns96925247EDD78SunnySD@68.6.19.6>

"g3000" <carlton_gregory_at_yahoo.com> wrote in news:1121266471.630211.296800_at_g44g2000cwa.googlegroups.com:

> I can log on to the database as sys ( sysdba ) with not problem and the
> session is created fast.
>
> I attempt to connect via another account and sometimes it will very
> quickly and sometimes it will just hang.
>
> Is there a way I can trace whats happening? I look for a trace file (
> bdump and udump ) but I dont see anything.
>
> I went in through the Enterprse Manager Console and the datafiles are
> not full ( the default tblspace for the user ). They have autoextend on
> anyway.
>
> Any ideas?
>
>

No idea, cuz you gave us no clues.
No OS name or version.
On version of Oracle to 4 decimal places.

place
ALTER SESSION SET SQL_TRACE=TRUE;
in your login.sql file Received on Wed Jul 13 2005 - 10:05:18 CDT