Strange processes
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Strange processes

Hybrid View

  1. #1
    Join Date
    Oct 2002
    Location
    london
    Posts
    41

    Strange processes

    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

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    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

  3. #3
    Join Date
    Oct 2002
    Location
    london
    Posts
    41
    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

  4. #4
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    check
    show parameters mts_
    show parameters parallel_

    u might have set multi threaded server settings
    siva prakash
    DBA

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    look

    v$bgprocess

  6. #6
    Join Date
    Oct 2002
    Location
    london
    Posts
    41
    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
    Last edited by blakmk; 11-21-2002 at 05:37 AM.

  7. #7
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    The ora_ixxx processes are dbwr slaves, look at the value of dbwr_io_slaves in your init.ora

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width