Month: March 2015

SYSTEMTAP Oracle session perf (CPU + WAITS) Direct SGA access (StapOra V0.2)

Mahmoud Hatem SYSTEMTAP , ,

UPDATE 26/05/2015 :  For the new version of StapOra including bug fixes and enhancement please click here

In the previous post i have developed a systemtap script to monitor CPU usage (Oracle CPU monitor version 0.1). So here i’am going to extend the script to include oracle wait events and CPU usage from the point of view of the oracle database using direct SGA access.

Here is a quick overview of the systemtap script (Renamed StapOra V0.2 )

  • Top wait events
  • Time spent on the run queue
  • IO wait time
  • Top kernel function
  • Top user function
  • Consistent Read by object
  • Consistent Read elapsed time and cpu time
  • Number of context switches

I will Explain here only the new added part and how it was developed:

Continue reading →

Profiling ORACLE CPU performance using SYSTEMTAP (Queuing time,cr,Top function call,Context switch,etc)

Mahmoud Hatem SYSTEMTAP , ,

UPDATE 26/05/2015 :  For the new version of StapOra (previously Oracle CPU monitor) including bug fixes and enhancement please click here

In this post i would like to provide one more option to investigate ORACLE CPU performance problem using SYSTEMTAP.

Here is a quick overview of the systemtap script (Oracle CPU monitor version 0.1):

  • Time spent on the run queue
  • IO wait time
  • Top kernel function
  • Top user function
  • Consistent Read by object
  • Consistent Read elapsed time and cpu time
  • Number of context switches

Description of the different part of the tool :

Continue reading →