Sybrand Bakker wrote:
> 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
Here's 2 sessions that took 3 minutes:
SID SEQ# EVENT
P1TEXT
P1 P1RAW P2TEXT
P2 P2RAW P3TEXT
P3 P3RAW WAIT_TIME
SECONDS_IN_WAIT STATE
---------- ----------
----------------------------------------------------------------
----------------------------------------------------------------
---------- --------
----------------------------------------------------------------
---------- --------
----------------------------------------------------------------
---------- -------- ---------- --------------- -------------------
15 207 SQL*Net message from client
driver id
1413697536 54435000 #bytes
1 00000001
0 00 0
6008 WAITING
19 16 SQL*Net message from client
driver id
1413697536 54435000 #bytes
1 00000001
0 00 0
3603 WAITING
Received on Wed Aug 11 2004 - 14:15:38 CDT
