LogMiner内存占用异常求助：Oracle 19.21单库PGA占用过高

我们通过LogMiner从多个数据库复制数据，其余数据库运行正常，仅某一数据库出现异常。

执行的命令如下：

EXECUTE DBMS_LOGMNR.ADD_LOGFILE( LOGFILENAME => '/oracle/arch/offline_log.dbf');
EXECUTE DBMS_LOGMNR.START_LOGMNR(OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG + DBMS_LOGMNR.COMMITTED_DATA_ONLY);
select count(*) from V$LOGMNR_CONTENTS where rownum <1000;
EXECUTE DBMS_LOGMNR.END_LOGMNR;

执行上述命令时，Oracle会话会分配4GB PGA内存；若移除where rownum <1000条件，会话将分配32GB PGA内存并因ORA-04030错误终止。其他数据库执行相同命令虽有类似症状，但使用自身重做日志文件仅需约40MB PGA。所有数据库版本均为19.21。

补充堆转储信息：

Additional info:
=======================================
PRIVATE MEMORY SUMMARY FOR THIS PROCESS
---------------------------------------
******************************************************
PRIVATE HEAP SUMMARY DUMP
3299 MB total:
  3298 MB commented, 512 KB permanent
   870 KB free (0 KB in empty extents),
  3278 MB,   2 heaps:   "Logminer LCR c "  646 KB free held

*** 2024-03-12 18:24:08.870
------------------------------------------------------
Summary of subheaps at depth 1
3298 MB total:
  3297 MB commented, 314 KB permanent  519 KB free (68 KB in empty extents),
  1929 MB, 1819373 chunks:  "krvuinl             " 2 KB free held
  1117 MB, 2729074 chunks:  "krvtadc1            " 3 KB free held

内容的提问来源于stack exchange，提问作者darvud