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

Thread: Strange processes

Threaded View

  1. #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 06:37 AM.

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