Few days ago i published a blog post talking about write consistency & DML restart . During my investigation i was interested in the function “dmltrace” and i noticed that this function was instrumented with the dbk*/dbg* debug functions introduced in 11g.
The question is how to enable this tracing facility ? Which events are checked by that function ?
We know how to extract the trace events number from the old ksdpec function (kernel service debug internal errors parser post event and check trigger condition using http://orafun.info/ of course 😀 ) thank to Dennis Yurichev see here and here.
We also know how to extract it from dbkdChkEventRdbmsErr (DB kernel debug check event of RDBMS error) thanks to Yong Huang see here.
But here the function is instrumented differently !
Continue reading →