Intermittent Spinning Shared Server Process
Last updated on AUGUST 06, 2010
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.4Linux 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 ()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
Changes
Reported upgrade to 10.2.0.4, but not confirmedCause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms