Process in Oracle 8.1.7.3.0

[mike2000]

Hi all,

I have a question about the processes in Oracle 8.1.7.3.0 particularly. Besizes the background processes, I also found there couple other processes running by Oracle.exe and I am not sure what are these processes is for??? This is only happened on Oracle 8.1.7.3.0 b/c 8.1.7.2.1 doesn't have these processes. I have DBArtisan and when I go to monitor, I found that these processes is running the package owned by SYS as follow:


begin
SYS.DBMS_IJOB.remove( :job);
end;


Can someone please tell me what are these processes are for ???

Thanks

[pando]

SNPx processes are used to run scheduled job (assumming they are called SNPx?)

[mike2000]

could please elaborate more about what you just explain ??? Please!!!!

[pando]

since you have not said what are the names of those extra processes I am assumming they are SNPx processes which are used to run scheduled jobs!

[mike2000]

Pando,

I am not sure if you mean this name

SYS SYSTEM 25292 TEST ORACLE.EXE BACKGROUND
SYS SYSTEM 36460 TEST ORACLE.EXE BACKGROUND
SYS SYSTEM 59820 TEST ORACLE.EXE BACKGROUND
SYS SYSTEM 59696 TEST ORACLE.EXE BACKGROUND
SYS SYSTEM 25300 TEST ORACLE.EXE BACKGROUND
SYS SYSTEM 23696 TEST ORACLE.EXE BACKGROUND
SYS [NULL] [NULL] [NULL] [NULL] USER
SYS [NULL] [NULL] [NULL] [NULL] USER
SYS [NULL] [NULL] [NULL] [NULL] USER
SYS [NULL] [NULL] [NULL] [NULL] USER
SYS [NULL] [NULL] [NULL] [NULL] USER
SYS [NULL] [NULL] [NULL] [NULL] USER
SYS [NULL] [NULL] [NULL] [NULL] USER
SYS [NULL] [NULL] [NULL] [NULL] USER
SYS [NULL] [NULL] [NULL] [NULL] USER
SYS [NULL] [NULL] [NULL] [NULL] USER

[dave777]

Check view SYS.V$BGPROCESS.

Regards.

[mike2000]

Dave777,

I did query the SYS.V$BGPROCESS and I think I found those processes are JOB_QUEUE_PROCESS. Another word I found 10 of these, and I set the JOB_QUEUE_PROCESSES=10 so another word, to whatever the number of process I set in the database, I am going to have that many number processes running in my database???

What is the function of these processes ??? why are they appear in the database. Can someone throw out some lights, please???

[pando]

hmm I have explained twice, those are used to run scheduled jobs!

And yes if you set to 10 then 10 of those snpX processes are started

[mike2000]

Thanks Pando