Why does my database generate a huge MMON trace file ?

Jun 2, 2023 7:42AM

Standalone Oracle Database 11.2.0.4 EE (Production environment / AIX 7.1 TL5)

Hi,

For several days, my database permanently generate mmon traces in a trc file which ends up becoming huge. The traces are always the same :

*** 2023-06-02 09:33:41.869

kspdmphblk: fh->kccfhfsz = 11, fh->kccfhbsz = 512

kspdmphblk: hblk->offset_ksphblk = 512, hblk->amount_ksphblk = 2010

kspdmphblk: phyblksize = 512, hdrblksize = 1023, format = 2

kspdmphblk: hdrblku = 10a41778, hdrblk = 10a41800

kspdmphblk: fh->kccfhfsz = 11, fh->kccfhbsz = 512

kspdmphblk: hblk->offset_ksphblk = 512, hblk->amount_ksphblk = 2010

kspdmphblk: phyblksize = 512, hdrblksize = 0, format = 2

kspdmphblk: hdrblku = 0, hdrblk = 10a41800

kspdmphblk: fh->kccfhfsz = 11, fh->kccfhbsz = 512

kspdmphblk: hblk->offset_ksphblk = 512, hblk->amount_ksphblk = 2010

kspdmphblk: phyblksize = 512, hdrblksize = 1023, format = 2

kspdmphblk: hdrblku = 10a41778, hdrblk = 10a41800

...

Not sure about what is going on... Did not find anything on Oracle Support or in the Internet. Nevertheless, the database seems to run well.

Database Administration (MOSC)