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

Thread: Top 5 Wait Events

  1. #1
    Join Date
    Nov 2000
    Posts
    440
    I run statspack and my main wait is this, and i have no idea what it is:



    Top 5 Wait Events
    ~~~~~~~~~~~~~~~~~ Wait % Total
    Event Waits Time (cs) Wt Time
    -------------------------------------------- ------------ ------------ -------
    PX Deq: Execution Msg 861 157,489 98.35

  2. #2
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    This is one of the main events used in a parallel query . It is used when the PQ slave is waiting to be told what to do. (eg: when waiting to be told parse / execute / fetch etc..)

    This is an idle wait and cannot be reduced.
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  3. #3
    Join Date
    Nov 2000
    Posts
    440
    what parameter in init.ora is responsable for this

  4. #4
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    PARALLEL_MIN_SERVERS

    PARALLEL_MAX_SERVERS

    PARALLEL_AUTOMATIC_TUNING = TRUE

    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

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