In this case our target is to get the data and the metrics on Oracle DB and show them as realtime dashboards on Bussion Analytics.
Bussion Analytics’ one of the preferred usage is as a consolidated NOC (Network Operations Center). Bussion Analytics gathers all the data about management softwares thus reporting and analyzing is possible on a single point. It is known that especially for IT Services Management lots of products of different suppliers are being used. You can use Bussion Analytics as an umbrella to gather all thes products quickly, easily and effectively. Thus metrics from different sources can be gathered, related and it will be easier to see&show the relation among them. For ex: A query send to Oracle – How much CPU & Disc used? How much Network Traffic caused? How long the query lasted? If that query affected other apps on Oracle? etc. Such parameters can be observed on the same time scale give us serious info about identifying problems.
For Oracle use case we prepared 2 dashboards. ORACLE OPERATIONS and ORACLE PERFORMANCE;
ORACLE OPERATIONS shows general metrics. Total Queries Scheme based queries, Group based queries etc. Thus is will be possible to see scheme or DB based queries numbers or contents in realtime.
Picture 1 – Dashboard View of Oracle Operations
Picture 2 – View of Active Queries on Oracle
From any widget on Dashboards you can go on details to see what are the queries running on Oracle. In pic2 you can see Scheme based running queries.
ORACLE PERFORMANCE dashboard contains detailed information on metrics and queries like;
All transactions and effects of these transactions can be monitored and managed real time or in a given time period via Bussion Analytics with the live dashboards.
Picture 3 – ORACLE PERFORMANCE Dashboard view
With Bussion Analytics manage all of your operations from one screen by combining data from different sources like IT Operations, Software Performances, Software Development, Test, Network, Trouble Tickets, etc.
For more information please contact us.