trace

ORA-1555 won’t get reported into alert.log anymore since 19.4.0

Posted on September 10, 2020 by Mike.Dietrich Behavior Change 8

Many thanks to a German customer for showing me this tiny behavior change with Oracle Database RU 19.4.0. From this RU on the well known ORA-1555 won’t get reported into alert.log anymore since 19.4.0. But if you still like to see the “snapshot too old” error, then you can use a workaround.

ORA-1555 won't get reported into alert.log anymore since 19.4.0

Photo by Dariusz Sankowski on Unsplash

Why has this been changed?

Actually this is something I don’t understand completely. It may be just a side effect. Unpublished fix bug 29424999 – DUMP MINIMAL DIAGNOSTICS BY DEFAULT IN CASE OF ORA-01555 IN ADW/ATP ENV has been …

RMAN backup generates traces in Oracle 12.2.0.1

Posted on May 24, 2018 by Mike.Dietrich Flaws and Pitfalls 5

RMAN backup generates traces in Oracle 12.2.0.1 Oracle 12.2.0.1 seems to be the “tracing” release without further patch or parameter treatments. After posting about MMON unconditional traces in Oracle 12.2.0.1 a day ago, I received a couple of comments either on the blog, via LinkedIn or Twitter regarding other trace facilities in Oracle Database 12.2.0.1. One of them is the case that RMAN backup generates traces in Oracle 12.2.0.1.

And please, very important upfront:
Oracle Database 12.2.0.1 is a very stable and reliable release based on all the customer feedback Roy and I received so far. For instance, when we check for optimizer issues …

MMON unconditional traces in Oracle 12.2.0.1

Posted on May 23, 2018 by Mike.Dietrich Flaws and Pitfalls 10

MMON unconditional traces in Oracle 12.2.0.1 I love visiting customers onsite. Last week I visited die Mobiliar in Bern, Switzerland. I received a list of open issues to discuss – which is very good to prepare a visit. And when we all were sitting together there was this “Ah, one final thing”. They have an issue with traces the databases writes every few seconds. As a remedy the DBAs increased the backup interval to remove the traces as otherwise the system would potentially run out of inodes or space. All the traces had the same pattern. And I learned quickly: these are MMON unconditional traces in …