Truncate DDL Increase Child Cursor Even if Patch 19239846 is Applied (Doc ID 2501128.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

Execution truncate DDL on partition increase child cursor even if patch 19239846 is applied
AWR shows high cursor: mutex S:
Top 10 Foreground Events by Total Wait Time
Event Waits Total Wait Time (sec) Wait Avg(ms) % DB time Wait Class
cursor: mutex S 61,551,077 389K 6 65.4 Concurrency >>> !!
library cache lock 1,016,781 141.1K 139 23.7 Concurrency >>> !!

The patch 19239846 prevent increasing child cursor if the cursor is KEPT when DDL happens (truncate only).

	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

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