Thursday, July 13, 2023

Oracle Database 12c -- The HEATMAP Segment is Top Consumer of SYSAUX

Problem

The HEATMAP segment is a top consumer of the SYSAUX tablespace and take considerable amount of space 

Solution

SQL> ALTER SYSTEM SET "_drop_stat_segment" =1;

No comments: