presman – DBRM Monitor

What is?

Presman is a Python utility that works with Python >2.6.x and cx_Oracle and pretends to be helpful as Oracle Database Resource Manager monitor. It works on 11g and 12c (non-PDB) Oracle Databases.

Current version: 1.2

What are the main features

1) Measure your CPU usage, sessions I/O and parallel servers and statements by Consumer Group
2) Show real time table and bar chart with a configurable refresh time;
3) Export measured data to a CSV to easy manipulate;
4) Configuration is easy and straightforward.

Limitations 

1) It doesn’t play well with PDB (Oracle 12c)
2) It doesn’t output colors on Windows

How to install?

For Windows 32/64 bits:
1) Download and install an updated version of Oracle client. 12c version is also supported;
2) Install Python 2.7.x (3.x is not supported) for Windows: https://www.python.org/downloads/windows/
3) Install cx_Oracle: https://pypi.python.org/pypi/cx_Oracle/5.1.3 – You can use 32 bits or 64 bits version
4) Download the zip of presman: https://github.com/lcmarques/presman/archive/master.zip and extract it to whatever you want.

For OSX:
1) Download and install an updated version of Oracle client. 12c version is also supported;
2) Python is already installed on OS X – Version 2.7.x on OSX Yosemite
3) You have to build cx_Oracle for yourself for now, but i’ve followed this instructions
4) Download the zip of presman: https://github.com/lcmarques/presman/archive/master.zip and extract it to whatever you want.

How to run it? 

/presman.py -m measure_name -o output_file -c column_id -p

Available measures:
cpu, parallel, session_io and emphasis

Example #1 – Measure CPU by Consumer Group and plot/text chart column with id 4:

./presman.py -m cpu -c 4 -p

Example #2 – Measure Parallel Servers and Statements by Consumer Group and output to file values in column with id 4:

./presman.py -m parallel -c 4 -o foobar.csv

Example #3 – Show the minimum CPU for each Consumer Group. Only supports the calculation with emphasis plan definition.

./presman.py -m emphasis

Download 

Latest Version: https://github.com/lcmarques/presman/archive/master.zip

Screenshots 

presman_session_io

Screenshot 2014-12-08 12.08.26

More information
– Features overview post #1: https://lcmarques.com/2014/12/07/presman-oracle-resource-manager-monitor/
– Code is available in github: https://github.com/lcmarques/presman

Contacts
Contact me at lcarapinha (at) gmail.com or twitter @drune

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s