Re: Books or links on Oracle Wait events (in depth)
- From: "Shastry(DBA)" <shastry17@xxxxxxxxx>
- To: Paul Drake <bdbafh@xxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 5 Oct 2010 09:23:06 +0530
Hi Paul,
Thanks for your response. Yes we are on 3 Node RAC setup but not on VM ware.
Thanks,
An
On Tue, Oct 5, 2010 at 9:11 AM, Paul Drake <bdbafh@xxxxxxxxx> wrote:
> Is this an Oracle RAC config on VMware ESX v2.5 where the system clock can
> get out of sync between VMs under load?
> If so, upgrade to ESXi v4.1 / vSphere.
>
>
>
> On Mon, Oct 4, 2010 at 11:33 PM, Paul Drake <bdbafh@xxxxxxxxx> wrote:
>
>> You're in luck.
>>
>> http://thinkoracle.blogspot.com/2005/11/oracle-insights-tales-of-oak-table.html
>> Chapter 7.
>>
>> If you need an instant remedy, this might fix you right up:
>>
>> http://books.google.com/books?id=b3DIkYO2gBQC&pg=PA9&lpg=PA9&dq=oracle+compulsive+tuning+disorder&source=bl&ots=yTXvCFe7xF&sig=yqsl1ZVbgG2VBtHLeldAvY0-6w8&hl=en&ei=upqqTN_0DsL78Aat8rSFBw&sa=X&oi=book_result&ct=result&resnum=5&sqi=2&ved=0CCkQ6AEwBA#v=onepage&q=oracle%20compulsive%20tuning%20disorder&f=false
>>
>> Seriously though, did the average waits get so large that they flipped to
>> be too large for a 32 bit integer and simply appear to be negative?
>>
>> -bdbafh
>>
>>
>> On Mon, Oct 4, 2010 at 11:19 PM, Shastry(DBA) <shastry17@xxxxxxxxx>wrote:
>>
>>> Hello Gurus,
>>>
>>> I would like to know if there is a book available to cover the below
>>> topics in depth. Please suggest.
>>> Does performance tuning books covers these areas or is there any
>>> different pointers which needs to be hit.
>>> Thanks in advance.
>>>
>>> EVENT COUNT(*) AVG(B.WAIT_TIME)
>>> ---------------------------------------- ---------- ----------------
>>> library cache pin 1 -1
>>> SQL*Net more data to dblink 1 0
>>> gc cr multi block request 1 0
>>> SQL*Net message from dblink 1 0
>>> enq: TX - row lock contention 1 0
>>> SQL*Net more data from client 1 0
>>> SQL*Net more data to client 2 -1
>>> latch: session allocation 2 .5
>>> control file sequential read 2 -1
>>> db file scattered read 2 0
>>> latch: cache buffers chains 3 -1
>>> read by other session 4 0
>>> latch free 4 -1
>>> gc buffer busy 4 -.25
>>> gc cr request 4 -.5
>>> SQL*Net message to client 5 -1
>>> wait for unread message on broadcast cha 7 0
>>> nnel
>>>
>>> pipe get 10 0
>>> db file sequential read 37 -.21621622
>>> Streams AQ: waiting for messages in the 51 0
>>> queue
>>>
>>> PL/SQL lock timer 59 0
>>> SQL*Net message from client 2185 3.11716247
>>>
>>> Regards,
>>> /An
>>>
>>
>>
>>
>
>
> --
> http://www.completestreets.org/faq.html
> http://safety.fhwa.dot.gov/ped_bike/docs/pamanual.pdf
>
>
Other related posts:
