Hi,
ladies and gentlemen,
Here
is a good one. We have 25 offices nation wide, running similar reports.
At the headquarters the one in consideration takes 12 min to complete.
Any other office (WAN) it gets stuck and takes a few hours if it completes
at all. Here is the output from V$SESSION_WAIT for the session:
SID SEQ# EVENT
P1TEXT
P1 P1RAW P2TEXT
P2 P2RAW P3TEXT
P3 P3RAW WAIT_TIME SEC_WT STATE
-----
--------- ------------------------- ---------- ---------
-------- ---------- --------- -------- ----------
--------- -------- --------- ------ ---------
82 31384 SQL*Net message from clie
driver id 675562835 28444553 #bytes
1 00000001
0 00
0 0 WAITING
After
some time:
SID SEQ# EVENT
P1TEXT
P1 P1RAW P2TEXT
P2 P2RAW P3TEXT
P3 P3RAW WAIT_TIME SEC_WT STATE
-----
--------- ------------------------- ---------- ---------
-------- ---------- --------- -------- ----------
--------- -------- --------- ------ --------
82 33799 SQL*Net message from clie
driver id 675562835 28444553 #bytes
1 00000001
0 00
0 0 WAITING
and
so on.(SEQ# increases and then resets).
At
the headquarters (LAN) it shows the same event after scattered read and
it is done. Could that be a SQL*Net issue between LAN and WAN?
Any
ideas are appreciated as always.
TIA,
Sergey
