informational trace files in 11g
Posted by John Hallas on June 16, 2009
Since Oracle 11G there seems to be many more informational trace files generated than ever before. Perhaps I am noticing more but I will provide three examples in support of what I am saying.
kcrroda: calling ksfdrcres to create AL or RL
Just a warning but it is due to a bug in 18.104.22.168 (still not fixed in 22.214.171.124) that causes diagnostic warnings to be issued after an archivelog switch. Bug 6910132 for anyone who is interested
From the same database I see trace files with the following lines in
Updating SGAs in kzam_check_limit
No rows for property:16, trail_type:12
Resetting MaxSize to default values for OS audit files
Resetting MaxSize to default values for XML audit files
No rows for property:17, trail_type:12
Resetting MaxAge to default values for OS audit files
Resetting MaxAge to default values for XML audit files
No rows for property:24, trail_type:15
I cannot find any information on this at all but I do suspect that it is another diagnostic setting that has been left enabled within the code
I will raise an SR on this matter but I don’t think it is anything for me to be worried by
From another database (again 126.96.36.199) I see numerous trace files containing the line
qerfxGCol:KQFDTTIM – Error converting to LdiDateArray
Metalink note 577674.1 shows that it is yet another trace output than can be ignored
Oracle Server – Enterprise Edition – Version: 188.8.131.52
This problem can occur on any platform.
After upgraded to 184.108.40.206.0 or created a new database on this version, you noticed following repetitively message at MMON process trace:
“qerfxGCol:KQFDTTIM – Error converting to LdiDateArray”
There is no further errors at alert log.
Upgraded to 220.127.116.11.0.
This issue has been introduced in 11gR1 18.104.22.168.0 with the new view v$persistent_queues, where a ‘select * from v$persistent_queues;’ reproduces the error when there is a ‘null’ value for one of timestamp
columns in that view. This behavior does *not* cause any data loss; performance impact nor any effect for use of ADDM/AWR tools.
This issue has been reported on following bugs:
Bug 6780602 – TRACEFILES WITH ‘QERFXGCOL:KQFDTTIM – ERROR CONVERTING TO LDIDATEARRAY’
Bug 6921602 – QERFXGCOL:KQFDTTIM – ERROR CONVERTING TO LDIDATEARRAY
It has been fixed in 11.2.