Oracle 19c Event mapping files

Here is the event mapping files for the new oracle 19c

• dbgdChkEventIntV_event_list_extended19c.txt
• oracle_function_to_event_mapping19c.txt
• oracle_function_to_event_mapping19c.sed

As usual this include new added/removed events  :

19c on the left/18c on the right

As i showed in my previous blog post this event mapping files can be used in different use cases.Such as flame graph annotation :

perf record -g -p 2022
perf script | FlameGraph-master/stackcollapse-perf.pl > out.perf-folded
cat out.perf-folded | sed -f oracle_function_to_event_mapping18c.sed > out_annotate.perf-folded
FlameGraph-master/flamegraph.pl out_annotate.perf-folded > perf-oracle_annotate.svg

 

 

We can also add some more information using Frits Hoogland script to add function names 😀

annotate_flamegraph.awk perf-oracle_annotate.svg > perf-oracle_annotate+.svg

That’s it have fun 😀