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
More information
– Features overview post #1: http://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