I have some strange processes on my database server. The have an os process id of ora_i### . V$session lists these as background sessions. Any ideas what these could be.
ora816 2186 1 0 Nov 15 ? 0:00 ora_i103_PH2
ora816 2150 1 0 Nov 15 ? 0:00 ora_pmon_PH2
ora816 2152 1 0 Nov 15 ? 0:00 ora_dbw0_PH2
ora816 2154 1 0 Nov 15 ? 0:00 ora_lgwr_PH2
ora816 2156 1 0 Nov 15 ? 0:00 ora_ckpt_PH2
ora816 2158 1 0 Nov 15 ? 0:01 ora_smon_PH2
ora816 2160 1 0 Nov 15 ? 0:00 ora_reco_PH2
ora816 2162 1 0 Nov 15 ? 0:00 ora_i201_PH2
ora816 2184 1 0 Nov 15 ? 0:00 ora_i102_PH2
ora816 2182 1 0 Nov 15 ? 0:00 ora_i101_PH2
ora816 5147 1 0 14:02:54 ? 0:00 oraclePH2 (LOCAL=NO)
ora816 2188 1 0 Nov 15 ? 0:00 ora_i104_PH2
11-20-2002, 06:34 AM
hrishy
Hi
These are not strange processes at all..they are normal processes..what oracle would call background processes..if any of them fail you oracle instance will come down...You can try shutting down the database and you will see that those process will go away..
They are essential...for the database to work..
regards
Hrishy
11-20-2002, 06:41 AM
blakmk
Im not talking about the smon, pmon, lgwr or dbwr processes. Im talking about the processes that have a prefix of ora_i###
ora816 2186 1 0 Nov 15 ? 0:00 ora_i103_PH2
ora816 2162 1 0 Nov 15 ? 0:00 ora_i201_PH2
11-20-2002, 07:03 AM
prakashs43
check
show parameters mts_
show parameters parallel_
u might have set multi threaded server settings
11-20-2002, 07:13 AM
pando
look
v$bgprocess
11-21-2002, 05:34 AM
blakmk
This shows
mts_max_dispatchers to be set to 5. Is this enough to invoke mts?
SQL> show parameters mts_
NAME TYPE VALUE
------------------------------------ ----------- -----------------------
mts_circuits integer 0
mts_dispatchers string
mts_listener_address string
mts_max_dispatchers integer 5
mts_max_servers integer 20
mts_multiple_listeners boolean FALSE
mts_servers integer 0
mts_service string PH2
mts_sessions integer 0
SQL> show parameters parallel
NAME TYPE VALUE
------------------------------------ ----------- -----------------------
parallel_server_instances integer 1
parallel_threads_per_cpu integer 2
recovery_parallelism integer 0
11-21-2002, 05:58 AM
jovery
The ora_ixxx processes are dbwr slaves, look at the value of dbwr_io_slaves in your init.ora