Forum Stats

  • 3,769,311 Users
  • 2,252,947 Discussions
  • 7,874,984 Comments

Discussions

SYSAUX tablespace is too large because of LOGMINER data

User_DUK8D
User_DUK8D Member Posts: 2 Green Ribbon
edited Jul 14, 2021 1:51PM in GoldenGate

Hi,

We are replicating realy big and high transaction volumed table with GoldenGate 19c MA. This table achives more than 100million DML's per day. So our sysaux tablespace was growing everyday. To stop the sysaux tablespace size I have changed the LOGMINER tablespace to the new one. But the new tablespace growing 1GB/per day. Is there any way to shrink this space or to control the growing?

thanks

Tagged:

Answers

  • ORASCN
    ORASCN Member Posts: 1,825 Gold Trophy

    Hi ,


    You need to have a dedicated tablespace for GoldenGate. It contains all the metadata information. By default it goes to SYSAUX tablespace. If your data is huge, then this would be expected.

    Are you also using CDR? or just only normal replication?


    Regards,

    Veera