Arch process running wild

8.1.5 SE
WNT4 After running workaround for
BUG:1300367 (Multiple Archiver processes started  can cause hang on shutdown) :
...

ALTER SYSTEM SET log_archive_max_processes=10; alter system archive log stop;
ALTER SYSTEM SET log_archive_max_processes=1; alter system archive log start;
...

few minutes later(without shutdown performed):

select 	p.spid		"SPID", 
	p.background	"BACKGROUND", 
	b.name 		"NAME", 
	s1.sid 		"SID", 
	s1.username	"USERNAME", 	
	s1.process  	"PROCESS", 
	s1.program 	"PROGRAM" 
from 	v$process p,v$session s1,
	v$bgprocess b 
where 	s1.paddr = p.addr 
and 	b.paddr(+) = p.addr 
order 	by s1.username;

SPID      B NAME       SID USERNAME      PROCESS   PROGRAM
--------- - --------- ---- ------------- --------- -----------
383                     33 ACC           483:401   psv.exe
397                      7 ACC           483:401   psv.exe
200                      8 DBSNMP        161:349   dbsnmp.exe
438         ARC5        11 FIN           74:282    psv.exe
439         ARC7        29 FIN           74:282    psv.exe
400         ARC8        32 MR            451:437   psv.exe
445                     20 MR            451:437   psv.exe
384                     22 MR            429401261 SQLPLUSW.EX
436                     25 MR            451:437   psv.exe
450                     24 TEST_10_A     429455485 SQLPLUSW.EX
498                     28 TEST_10_M     1220:1104 SQLPLUSW.EX
305       1 PMON         1               305       ORACLE.EXE
310       1 DBW0         2               310       ORACLE.EXE
324       1 LGWR         3               324       ORACLE.EXE
497       1 ARC3        21               497       ORACLE.EXE
406       1 ARC6        16               406       ORACLE.EXE
406       1 ARC4        16               406       ORACLE.EXE
334       1 ARC2        30               334       ORACLE.EXE
476       1 ARC1         9               476       ORACLE.EXE
339       1 CKPT         4               339       ORACLE.EXE
342       1 SMON         5               342       ORACLE.EXE
359       1 RECO         6               359       ORACLE.EXE
459       1 ARC0        19               459       ORACLE.EXE

How is it possible
for alpplication
(3rd party software - "psv.exe" above, has it's own driver) to start Archiver background process ??? It's not showing "1" under p.background "BACKGROUND" OS Nt process?
Same with some java apps (and JDBC(?)).

does it look like might corrupt stuff??

zhix Received on Wed Apr 17 2002 - 15:57:23 CDT