AIX : OLSON TZ result in performance and eviction (Doc ID 2215971.1)

Last updated on JANUARY 20, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
IBM AIX on POWER Systems (64-bit)

Symptoms

Node was crashing randomly .

2016-12-11 22:12:55.954:
[cssd(3277434)]CRS-1612:Network communication with node xxxxxxxx (1) missing for 50% of timeout interval. Removal of this node from cluster in 14.111 seconds <<<<<<<<<<
2016-12-11 22:13:02.977:
[cssd(3277434)]CRS-1611:Network communication with node xxxxxxxx (1) missing for 75% of timeout interval. Removal of this node from cluster in 7.088 seconds
2016-12-11 22:13:07.998:
[cssd(3277434)]CRS-1610:Network communication with node xxxxxxxx (1) missing for 90% of timeout interval. Removal of this node from cluster in 2.067 seconds

 

[cssd(3080252)]CRS-1719:Cluster Synchronization Service daemon (CSSD) clssnmPollingThread not scheduled for 7811 msecs. <<<<<<<<<<<<<<<<<<
2016-12-11 22:12:48.126:
[cssd(3080252)]CRS-1719:Cluster Synchronization Service daemon (CSSD) clssnmSendingThread not scheduled for 8061 msecs.
2016-12-11 22:12:56.128:
[cssd(3080252)]CRS-1719:Cluster Synchronization Service daemon (CSSD) clssnmPollingThread not scheduled for 15813 msecs.
2016-12-11 22:12:56.128:
[cssd(3080252)]CRS-1719:Cluster Synchronization Service daemon (CSSD) clssnmSendingThread not scheduled for 16062 msecs.
2016-12-11 22:13:04.130:
[cssd(3080252)]CRS-1719:Cluster Synchronization Service daemon (CSSD) clssnmPollingThread not scheduled for 23815 msecs.
2016-12-11 22:13:04.130:
[cssd(3080252)]CRS-1719:Cluster Synchronization Service daemon (CSSD) clssnmSendingThread not scheduled for 24064 msecs.
2016-12-11 22:41:26.375:
[client(1836270)]CRS-2302:Cannot get GPnP profile. Error CLSGPNP_NO_DAEMON (GPNPD daemon is not running).

 

 

 and database performance was slow.

=> Oracle session identified by:
{
instance: 3 (nnnnn.nnnnn3)
os id: 11536112
process id: 911, oracle@xxxx03
session id: 3715
session serial #: 57079
}
which is waiting for 'log file switch completion' with wait info:
{
time in wait: 0.041610 sec
timeout after: never
wait id: 1763160
blocking: 1 session
current sql: <none>
short stack: ksedsts()+240<-ksdxfstk()+44<-ksdxcb()+3432<-sspuser()+116<-__sighandler()<-stat()+24<-olson_tzset()+180<-olson_localtime()+28<-localtime64_tz_ost_r()+16<-localtime64_tz_r()+840<-localtime_r()+24<-localtime_r()+128<-slgtds()+60<-slgtd()+16<-dtegtdi()+52<-psdsysdt()+92<-pessdt()+64<-pevm_icd_call_common()+300<-pfrinstr_BCAL()+84<-pfrrun_no_tool()+96<-pfrrun()+1032<-plsql_run()+616<-peicnt()+324<-kkxexe()+484<-opiexe()+17356<-kpoal8()+2092<-opiodr()+908<-ttcpip()+1028<-opitsk()+1612<-opiino()+940<-opiodr()+908<-opid
wait history:
* time between current wait and wait #1: 0.000279 sec
1. event: 'SQL*Net message from client'
time waited: 0.000883 sec
wait id: 1763159 p1: 'driver id'=0x54435000
p2: '#bytes'=0x1
* time between wait #1 and #2: 0.000014 sec


Chain 1 Signature: 'log file switch completion'<='enq: TX - row lock contention'

File_name :: nnnnn3_ora_8455042.trc

 

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