What causes a connection attempt via sqlplus to hang?

From: g3000 <carlton_gregory_at_yahoo.com>
Date: 13 Jul 2005 07:54:31 -0700
Message-ID: <1121266471.630211.296800@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? Received on Wed Jul 13 2005 - 09:54:31 CDT