FAQ
Hi,
Can someone explain the wait events like rdbms ipc message, jobq slave wait, PX Deque wait, direct path read, enqueue and how to tackle them. Thanks

Search Discussions

  • ������ at Jul 22, 2008 at 2:00 am
    What a list of wait events!!! :)

    That's why Oracle has built the support site called metalink and supplied
    official manual documents.

    Dion Cho

    2008/7/22 A Joshi :
    Hi,
    Can someone explain the wait events like rdbms ipc message, jobq slave
    wait, PX Deque wait, direct path read, enqueue and how to tackle them.
    Thanks

    --
    http://www.freelists.org/webpage/oracle-l
  • Sergey Popov at Jul 22, 2008 at 2:34 am
    You will fine a good explanation of wait interface in this book:

    http://www.amazon.com/Oracle-Wait-Interface-Performance-Diagnostics/dp/007222729X/ref=pd_bbs_sr_1?ie=UTF8&s=books&qid=1216693950&sr=8-1
    On Mon, Jul 21, 2008 at 9:54 PM, A Joshi wrote:
    Hi,
    Can someone explain the wait events like rdbms ipc message, jobq slave
    wait, PX Deque wait, direct path read, enqueue and how to tackle them.
    Thanks
    --
    http://www.freelists.org/webpage/oracle-l
  • Fuad Arshad at Jul 22, 2008 at 3:37 am
    I think Steve Adams still has some details at ixora.com.au
    Hope that helps

    On Jul 21, 2008, at 8:54 PM, A Joshi wrote:

    Hi,
    Can someone explain the wait events like rdbms ipc message, jobq slave wait, PX Deque wait, direct path read, enqueue and how to tackle them. Thanks
  • Jared Still at Jul 22, 2008 at 4:13 pm
    Before learning how to 'fix' them, you need to learn how to determine
    which, if any, of them are actually a problem.

    What are you trying to accomplish?

    Reduce numbers seen on a statspack report?

    User complaining about performance?
    On Mon, Jul 21, 2008 at 6:54 PM, A Joshi wrote:

    Hi,
    Can someone explain the wait events like rdbms ipc message, jobq slave
    wait, PX Deque wait, direct path read, enqueue and how to tackle them.
    Thanks

    --
    Jared Still
    Certifiable Oracle DBA and Part Time Perl Evangelist

    --
    http://www.freelists.org/webpage/oracle-l

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJul 22, '08 at 1:54a
activeJul 22, '08 at 4:13p
posts5
users5
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase