Oracle 19c Event mapping files

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

As usual this include new added/removed events  :

Capture 01

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

 

Capture 02

 

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

Capture 03

That’s it have fun 😀

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s