Spinning on CPU waiting for latch
- From: "Chitale, Hemant K" <Hemant-K.Chitale@xxxxxx>
- To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 22 May 2014 10:39:40 +0800
If a database server process is in a "spin loop" on CPU waiting for a
latch, does ASH show status='ON CPU' or status='WAITING' with the event
being the latch wait.
Just wondering.....
I can't create a test case.
It doesn't matter for a single process but when you have dozens and
hundreds of processes going through this during the day, there should be
a noticeable difference between the OS's cpu %usr and Oracle ASH's 'ON
CPU' --- as it is there is always a difference because ASH samples in
V$ are every second while in DBA_HIST are 1 in 10 samples only.
Hemant K Chitale
This email and any attachments are confidential and may also be privileged. If
you are not the intended recipient, please delete all copies and notify the
sender immediately. You may wish to refer to the incorporation details of
Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at
https://www.sc.com/en/incorporation-details.html.
Other related posts:
