SNP PROCESSES!!! HELP NEEDED!!!!!

hi ,

I have observed cpu-time=0 twice on my unix machine running ORACLE 7.3.2, dbshut/dbstart solves the problem, but i am not able to get to any conclusion.

The SNP0,SNP1,SNP2,SNP3 are eating away all CPU.(all user process are eating time, with small io and system process)

the oracle server (on unix) is in multi-master configuraton with 2 others(on NT), refresh interval is 1 minute, no of job_process=4, the shared memory is 40MB, job_queu_interval is 10 sec, the no of updates i think are not large.

TRACE FILE SHOWS :

• SESSION ID:(9.3127) 1998.12.17.15.03.46.330 ORA-12012: error on auto execute of job 2 ORA-23324: error ORA-04052: error occurred when looking up remote object SURROGATE.SYS_at_MGMT2.WORLD ORA-00604: error occurred at recursive SQL level 3 ORA-12203: TNS:unable to connect to destination ORA-12203: TN, while creating deferror entry at "MGMT2.WORLD" with error
  -12203 ORA-06512: at "SYS.DBMS_DEFER_SYS", line 585 ORA-06512: at line 1 Thu
  Dec 17 15:06:18 1998 Thu Dec 17 15:06:18 1998 *** SESSION ID:(9.3129) 1998.12.17.15.06.18.270 ORA-12012: error on auto execute of job 2 ORA-23324: error ORA-04052: error occurred when looking up remote object SURROGATE.SYS_at_MGMT2.WORLD ORA-00604: error occurred at recursive SQL level 3 ORA-12203: TNS:unable to connect to destination ORA-12203: TN, while creating deferror entry at "MGMT2.WORLD" with error -12203 ORA-06512: at "SYS.DBMS_DEFER_SYS", line 585 ORA-06512: at line 1 Thu Dec 17 15:08:50 1998

WHEREAS ALL REMOTE OBJECTS ARE PRESENT and LINKS ARE ACTIVE.

thanks for any help.
naveen

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Dec 31 1998 - 00:51:46 CST