Execution of a JSP that Spawns User Threads That Read from Process Streams May Result in an HANG When Resource Manager is Active (OJVM: Generic Wait Event in v$session_wait)
(Doc ID 1360865.1)
Last updated on JUNE 05, 2019
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterOracle 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
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Checked for relevance on 29-May-2019
Symptoms
Java stored procedure hangs with wait on OJVM: Generic. This occurs only if Resource Manager is active.
SQL> select event from v$session_wait where sid = 100;
EVENT
----------------------------------------------------------------
OJVM: Generic
The errorstack placed on the session indicates high waits on this event:
---------------------------------------------------
Sampled Session History Summary:
longest_non_idle_wait: 'OJVM: Generic'
[3 samples, 09:07:20 - 09:07:22]
time_waited: >= 2 sec (still in wait)
---------------------------------------------------
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |