My Oracle Support Banner

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

Last updated on APRIL 23, 2018

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

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
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.