Database Sessions May Intermittently Hang or Timeout When a Juniper Firewall is Present
(Doc ID 2351192.1)
Last updated on NOVEMBER 04, 2019
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
- Upgraded Oracle E-Business Database from 22.214.171.124 to 126.96.36.199 and application processes hang
- Each involves a client/server connection in either the form of an application connecting to the instance from another server or access via a db link from another database. Session becomes inactive but also unresponsive
- AWR just shows 'norma' CPU wait:
Top 10 Foreground Events by Total Wait Time
Event Waits Total Wait Time (sec) Wait Avg(ms) % DB time Wait Class
DB CPU 80.4 92.2
cell single block physical read 5,139 2.7 0.52 3.1 User I/O
control file sequential read 13,379 2.5 0.19 2.9 System I/O
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