The kPerf for Oracle uses Prometheus and Grafana for storing and visualizing data. The core of kPerf is written in Python, which collects and calculates data.

In my opinion, the most powerful feature of kPerf for Oracle is the combination of historically captured data and relevant multidimensional metrics, which you can aggregate, analyze, compare, etc.

Features

• kPerf for Oracle does not require creating any objects inside the Oracle database or access to ASH.
• kPerf for Oracle does not require the Diagnostic or Tuning pack to collect metrics from the Oracle database.
• You only need to create a user in the database and grant the necessary privileges.
• The password for the user will be encrypted and stored in the config file.
• kPerf operates in a true PULL mode to improve precision. What does this mean? It means that all metrics for all modules begin to be collected only when someone performs a GET request.
• Metrics have several labels (dimensions), and you can join them with other metric and filter them.

All collected data is processed in kPerf(Python). The collected data is stored in Prometheus. Grafana is used for data visualization (dashboards are included). Currently, data is collected from:

• cdb_data_files
• v_$system_event
• v_$sysstat
• v_$sqlarea
• v_$sys_time_model
• v_$sess_time_model
• v_$session
• v_$sqlcommand
• v_$session_event
• v_$sesstat
• dba_segments
• dba_data_files

Usage

• Database Performance Monitoring: The system allows real-time analysis of database activity, identifying bottlenecks and problematic queries.
• Performance Issue Diagnosis: Use data on wait events, system statistics, and SQL execution to detect and resolve performance issues.
• Long-term Trend Analysis: Store historical data in Prometheus to identify patterns in database resource usage.
• Integration with Existing Monitoring Systems: Visualization via Grafana can be seamlessly integrated into existing infrastructure.

Full description of The kPerf for Oracle is available on GitHub: https://github.com/krotovks/kPerf_for_Oracle

Additional features will be available in the next release.