Intermittent Spinning Shared Server Process
(Doc ID 1126166.1)
Last updated on FEBRUARY 25, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.4 and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Linux x86
Red Hat Enterprise Linux Advanced Server Itanium
Issue recorded as Linux specific (rehat) but may effect other linux platforms.
To date issue only recorded for customers with redhat.
Symptoms
Intermittent shared server process spins, taking high amount of CPU.This started to happened after Oracle home was upgraded to 10.2.0.4. No errors are reported in any log file.
Pstack of the spinning process.
Thread 1 (Thread -1241564928 (LWP 11862)):
#0 0x006108d1 in gettimeofday () from /lib/tls/libc.so.6
#1 0x0aa13912 in gethrtime ()
#2 0x0965b26b in sdtgtm ()
#3 0x08301f53 in kstrec ()
#4 0x08326971 in kslwte_tm ()
#5 0x08327a7b in ksliwat ()
#6 0x0832835f in kslwaitns_timed ()
#7 0x084ac0ea in kskthbwt ()
#8 0x083282d7 in kslwait ()
#9 0x0962f5b7 in kmcgms ()
#10 0x08d009c3 in opitsk ()
#11 0x08d02225 in opiino ()
#12 0x08d0360c in opiodr ()
#13 0x0a3ce4f5 in opirip ()
#14 0x08cf8aea in opidrv ()
#15 0x0965dc6b in sou2o ()
#16 0x082c8082 in opimai_real ()
#17 0x082c7eff in main ()
#0 0x006108d1 in gettimeofday () from /lib/tls/libc.so.6
#1 0x0aa13912 in gethrtime ()
#2 0x0965b26b in sdtgtm ()
#3 0x08301f53 in kstrec ()
#4 0x08326971 in kslwte_tm ()
#5 0x08327a7b in ksliwat ()
#6 0x0832835f in kslwaitns_timed ()
#7 0x084ac0ea in kskthbwt ()
#8 0x083282d7 in kslwait ()
#9 0x0962f5b7 in kmcgms ()
#10 0x08d009c3 in opitsk ()
#11 0x08d02225 in opiino ()
#12 0x08d0360c in opiodr ()
#13 0x0a3ce4f5 in opirip ()
#14 0x08cf8aea in opidrv ()
#15 0x0965dc6b in sou2o ()
#16 0x082c8082 in opimai_real ()
#17 0x082c7eff in main ()
Strace shows spinn on "gettimeofday"
11862 0.000049 poll([{fd=14, events=POLLIN|POLLRDNORM,
revents=POLLIN|POLLRDNORM|POLLHUP}], 1, 30000) = 1 <0.000011>
11862 0.000052 read(14, 0xbfff6df8, 2000) = -1 EAGAIN (Resource
temporarily unavailable) <0.000010>
11862 0.000047 gettimeofday({1245352406, 186540}, NULL) = 0 <0.000009>
11862 0.000047 gettimeofday({1245352406, 186588}, NULL) = 0 <0.000009>
11862 0.000048 gettimeofday({1245352406, 186635}, NULL) = 0 <0.000009>
11862 0.000047 gettimeofday({1245352406, 186683}, NULL) = 0 <0.000009>
11862 0.000048 gettimeofday({1245352406, 186730}, NULL) = 0 <0.000009>
11862 0.000048 gettimeofday({1245352406, 186778}, NULL) = 0 <0.000009>
11862 0.000048 poll([{fd=14, events=POLLIN|POLLRDNORM,
revents=POLLIN|POLLRDNORM|POLLHUP}], 1, 30000) = 1 <0.000011>
11862 0.000052 read(14, 0xbfff6df8, 2000) = -1 EAGAIN (Resource
temporarily unavailable) <0.000015>
11862 0.000058 gettimeofday({1245352406, 186940}, NULL) = 0 <0.000009
revents=POLLIN|POLLRDNORM|POLLHUP}], 1, 30000) = 1 <0.000011>
11862 0.000052 read(14, 0xbfff6df8, 2000) = -1 EAGAIN (Resource
temporarily unavailable) <0.000010>
11862 0.000047 gettimeofday({1245352406, 186540}, NULL) = 0 <0.000009>
11862 0.000047 gettimeofday({1245352406, 186588}, NULL) = 0 <0.000009>
11862 0.000048 gettimeofday({1245352406, 186635}, NULL) = 0 <0.000009>
11862 0.000047 gettimeofday({1245352406, 186683}, NULL) = 0 <0.000009>
11862 0.000048 gettimeofday({1245352406, 186730}, NULL) = 0 <0.000009>
11862 0.000048 gettimeofday({1245352406, 186778}, NULL) = 0 <0.000009>
11862 0.000048 poll([{fd=14, events=POLLIN|POLLRDNORM,
revents=POLLIN|POLLRDNORM|POLLHUP}], 1, 30000) = 1 <0.000011>
11862 0.000052 read(14, 0xbfff6df8, 2000) = -1 EAGAIN (Resource
temporarily unavailable) <0.000015>
11862 0.000058 gettimeofday({1245352406, 186940}, NULL) = 0 <0.000009
Changes
Reported upgrade to 10.2.0.4, but not confirmed
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |