My Oracle Support Banner

High Latch: Row Cache Objects With VPD Cause The Database To Be Non Responsive (Doc ID 2484574.1)

Last updated on MARCH 04, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

High latch: row cache objects cause the database to be  non responsive

Problem Description
---------------------------------------------------
Top 10 Foreground Events by Total Wait Time

Event Waits Total Wait Time (sec) Wait Avg(ms) % DB time Wait Class
DB CPU 30.9K 44.9
latch: row cache objects 3,584,480 19.5K 5 28.3 Concurrency


Top 10 Foreground Events by Total Wait Time

DB CPU 30.9K 44.9
latch: row cache objects 3,584,480 19.5K 5 28.3 Concurrency
db file sequential read 4,351,598 7069.9 2 10.3 User I/O
enq: TX - row lock contention 680 2701.7 3973 3.9 Application
direct path read 442,632 889 2 1.3 User I/O
log file sync 229,734 880.9 4 1.3 Commit
control file sequential read 954,180 610.1 1 .9 System I/O
library cache: mutex X 321,764 601.8 2 .9 Concurrency
SQL*Net more data to client 5,130,233 242.5 0 .4 Network
cursor: mutex X 330,249 192.8 1 .3 Concurrency


Time Model Statistics
sql execute elapsed time 36,014.72 52.33


Foreground Wait Events
latch: row cache objects 3,584,480 0 19,506 5 11.84 28.34
db file sequential read 4,351,598 0 7,070 2 14.37 10.27


Trace file ***_ora_30583.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = ******/orace/product/11r2
System name: Linux
Node name: <node>
Release: 2.6.32-504.30.3.el6.x86_64
Version: #1 SMP Wed Jul 15 10:13:09 UTC 2015
Machine: x86_64
Redo thread mounted by this instance: 1
Oracle process number: 67
Unix process pid: 30583, image: oracle@<node> (TNS V1-V3)


*** 2018-10-10 08:45:58.230
*** SESSION ID:(5978.57291) 2018-10-10 08:45:58.230
*** CLIENT ID:() 2018-10-10 08:45:58.230
*** SERVICE NAME:(SYS$USERS) 2018-10-10 08:45:58.230
*** MODULE NAME:(sqlplus@db (TNS V1-V3)) 2018-10-10 08:45:58.230
*** ACTION NAME:() 2018-10-10 08:45:58.230

Chains most likely to have caused the hang:
 [a] Chain 1 Signature: 'SQL*Net message from client'<='latch: row cache objects'
     Chain 1 Signature Hash: 0xdcf6a6c4
 [b] Chain 2 Signature: 'SQL*Net message from client'<='latch: row cache objects'
     Chain 2 Signature Hash: 0xdcf6a6c4
 [c] Chain 3 Signature: 'db file sequential read'<='enq: TX - row lock contention'
     Chain 3 Signature Hash: 0xa22f6552




Source file : ****_ora_30583.trc

KGL/KQR Stacks captured.

System State 1 (2018-10-10 08:46:11.972)
~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~
....
50: waiting for 'library cache: mutex X'
...
66: waiting for 'latch: row cache objects'
...
84: waiting for 'db file sequential read' (0xcfd,0x2f925f,0x1)
...
234:waiting for 'db file sequential read' (0x680,0x169bd7,0x1)
...



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
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.