Hi all, Oracle database 10.2.0.4 EE Sun OS 5.10 Getting "ORA-12592: TNS:bad packet" upon MV refresh 4 - 5min after executing the code: begin dbms_mview.refresh ( list => '<mv_name>', method => 'c', atomic_refresh => false ); end; / ORA-12008: error in materialized view refresh path ORA-12592: TNS:bad packet ORA-02063: preceding line from <edit> ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2251 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2457 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2426 ORA-06512: at line 2 100% reproducible. The underling query runs without error. SQL trace: WAIT #28: nam='SQL*Net more data from dblink' ela= 1502827 driver id=675562835 #bytes=1 p3=0 obj#=-1 tim=120596825715063 WAIT #28: nam='SQL*Net break/reset to dblink' ela= 38 driver id=675562835 break?=1 p3=0 obj#=-1 tim=120596825715263 WAIT #28: nam='SQL*Net break/reset to dblink' ela= 49889 driver id=675562835 break?=0 p3=0 obj#=-1 tim=120596825765231 WAIT #28: nam='direct path write' ela= 3 file number=11 first dba=669504 block cnt=32 obj#=-1 tim=120596825765613 EXEC #28:c=19580000,e=245790469,p=0,cr=1760,cu=36671,mis=0,r=0,dep=1,og=1,tim=120596825779551 ERROR #28:err=12592 tim=3759180367 Oracle*Net trace: [000002 29-OCT-2013 19:26:37:945] nioqrc: found a break marker... [000002 29-OCT-2013 19:26:37:945] nioqrc: Recieve: returning error: 3111 [000002 29-OCT-2013 19:26:37:945] nioqrc: exit [000002 29-OCT-2013 19:26:37:945] nioqrs: entry [000002 29-OCT-2013 19:26:37:945] nioqrs: state = interrupted (1) [000002 29-OCT-2013 19:26:37:945] nscontrol: entry [000002 29-OCT-2013 19:26:37:945] nscontrol: cmd=1, lcl=0x0 [000002 29-OCT-2013 19:26:37:945] nscontrol: normal exit [000002 29-OCT-2013 19:26:37:945] nioqrs: state = interrupted (1) [000002 29-OCT-2013 19:26:37:945] nioqrs: nioqrs: sending reset marker... [000002 29-OCT-2013 19:26:37:945] nioqsm: entry [000002 29-OCT-2013 19:26:37:945] nioqsm: Sending reset packet (2)... The network guys say "no problem on the network side". Next step -> SR, in the mean time, any ideas? Thanks Dimitre -- //www.freelists.org/webpage/oracle-l