6f429244e498457b8400e72e4af683b0 Alberto Blog: Oracle Dashboard in Graylog

martedì 27 ottobre 2015

Oracle Dashboard in Graylog

As you know for the SE version is not covered performance in OEM, so you can not see the real-time DB performance.
This is a limitation (license) commissioned by Oracle for the SE, but given the continued growth and spread of this release, I thought a way to fill a bit this absence.
Graylog is an open source software for log management that lets you index, historical context, for further analysis, any type of log and not structured, servers and platforms.
My idea:


  • logstash to capture SQL statements connecting to the database and then send them to the server graylog
  • Graylog server to centralize all SQL statements in real-time and create dashboards.

I created a repository on github where explain these steps for installation and related resources used in my working setup.

When I connect my instance graylog I can check each sql statement executed ASH (I deliberately obscured sql statement):






















Creating dashboards with Graylog, based on what you want to analyze, the reading is much easier and immediate:



























Yuo can find all here in Graylog Market....

Enjoy !!!

2 commenti:

Praveen Kumar ha detto...

Valuable information thanks for sharing Oracle DBA Online Training

Praveen Kumar ha detto...

Valuable information thanks for sharing Oracle DBA Online Training

Posta un commento