High Latch: Row Cache Objects With VPD Cause The Database To Be Non Responsive
(Doc ID 2484574.1)
Last updated on JULY 20, 2024
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 |