Strange processes

[blakmk]

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

[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

[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

[prakashs43]

check
show parameters mts_
show parameters parallel_

u might have set multi threaded server settings

[pando]

look

v$bgprocess

[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
------------------------------------ ----------- -----------------------
fast_start_parallel_rollback string LOW
optimizer_percent_parallel integer 0
parallel_adaptive_multi_user boolean TRUE
parallel_automatic_tuning boolean TRUE
parallel_broadcast_enabled boolean FALSE
parallel_execution_message_size integer 4096
parallel_instance_group string
parallel_max_servers integer 40
parallel_min_percent integer 0
parallel_min_servers integer 0
parallel_server boolean FALSE

NAME TYPE VALUE
------------------------------------ ----------- -----------------------
parallel_server_instances integer 1
parallel_threads_per_cpu integer 2
recovery_parallelism integer 0

[jovery]

The ora_ixxx processes are dbwr slaves, look at the value of dbwr_io_slaves in your init.ora

Regards