Intermittent Spinning Shared Server Process (Doc ID 1126166.1)

Last updated on AUGUST 06, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 and later   [Release: 10.2 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 ()

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 confirmed

Cause

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