18c Row Cache Lock On Dc_tablespace_quotas Observed When Truncating Table
(Doc ID 2670599.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 18.3.0.0.0 and later Information in this document applies to any platform.
Symptoms
When truncating table on 18c, row cache lock on dc_tablespace_quotas is observed
The problem didn't occur in 11gR2
Tablespace is not bigfile tablespace in this case
Tracefile shows following:
Current Wait Stack: 0: waiting for 'row cache lock' cache id=0x5, mode=0x0, request=0x5 <=== Cache id = 0x5 indicates that it is "dc_tablespace_quotas" row cache lock on 18c
Callstack has kqrpre < kttusq
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!