High Wait On "gc quiesce" Caused By TRUNCATE In RAC Environment (Doc ID 2681954.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

High waiting events on "gc quiesce" caused by TRUNCATE in RAC environment from AWR report.

Top 10 Foreground Events by Total Wait Time

Event   Waits   Total Wait Time (sec)   Avg Wait   % DB time   Wait Class
gc quiesce   5,014   5011.1   999.42ms   68.8   Cluster

Top SQL with Top Events

SQL ID   Plan Hash   Executions   % Activity   Event   % Event   Top Row Source   % Row Source   SQL Text
06s29sy3ctt4r   191391321   94   11.03    gc quiesce   9.62   DDL STATEMENT   9.62    TRUNCATE TABLE <TABLE_NAME1>
dd3zxfc71ujfv   2062434418   70   8.22    gc quiesce   7.16   DDL STATEMENT   7.16    TRUNCATE TABLE <TABLE_NAME2>...
cnxy236h2tbxq   2253046699   59   6.92    gc quiesce   6.46   DDL STATEMENT   6.46    TRUNCATE TABLE <TABLE_NAME3>...
9vw5w7w1c5g1f   29575690   50   5.87    gc quiesce   5.28   DDL STATEMENT   5.28    TRUNCATE TABLE <TABLE_NAME4>
bujxytwy6kshh   843676785   44   5.16    gc quiesce   5.05   DDL STATEMENT   5.05    TRUNCATE TABLE <TABLE_NAME5>

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

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