Session Hang During Insert With Parallel Dml
(Doc ID 2652092.1)
Last updated on JULY 15, 2021
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
session hang during insert with parallel dml
From the Hang Analyze found that same ISNERT is running from sessions and one session is blocking by other.
On further investigation found that issue is due to the Unified auditing on.
Unified Auditing TRUE
With unified auditing off and audit trail is set to "DB,extended" the query is running very fast.
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