Problem running a report

[Babich , Sergey]

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