Re: connection on 9i sometimes hangs

On Wed, 11 Aug 2004 09:48:27 -0700, M Rothwell <ThisIsABadAddress_at_toobad.com> wrote:

>We just upgraded from an 8i db to a 9i db on HP-UX.
>
>I access the db from a Windows XP box with DBArtisan.
>
>When we had the 8i db, I never had any problems, but every since we
>upgraded to 9i I sometimes hang while navigating different objects in
>DBArtisan. I also have a 9i db local (on same XP box) that has no
>problems with DBArtisan. This leads me to believe that it is a TNS
>issue. I've checked logs on client and server and cannot find anything
>odd. When it hangs, it is generally about 3 minutes, then everthing is
>ok.
>
>Any ideas what would/could cause this?
>
>Thank you,

A better analysis would be in order.
Identify the sid of your session, then use v$session_wait to check out what it is waiting for.

--
Sybrand Bakker, Senior Oracle DBA