Analyzing performance of an ORACLE database using perf (perf_events) on VMWARE

Sometimes we need to deeg deeper to understand what’s going on. Recently i was faced with a problem to tune a session consuming a lot of CPU power, so i begin by analysing the session stats and to get more info i decided to use the perf tool to do some investigation (based on hardware events) but i was unable to do that. After some checks it appears that the system was running on a virtual machine.

Continue reading