LucaCanali/Oracle_DBA_scripts

Stars
50
Rank 577,233 (Top 12 %)
Language PLSQL
License
GNU General Publi...
Created over 9 years ago
Updated over 9 years ago

LucaCanali/Oracle_DBA_scripts

LucaCanali

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

A collection of old-school CLI scripts for Oracle RDBMS monitoring and performance troubleshooting.

sparkMeasure

This is the development repository for sparkMeasure, a tool for performance troubleshooting of Apache Spark workloads. It simplifies the collection and analysis of Spark task and stage metrics data.

Miscellaneous

Includes notes on Apache Spark, Spark for Physics, Jupyter notebook examples for Spark, Oracle and other DB systems.

Jupyter Notebook

Linux_tracing_scripts

Scripts and tools for troubleshooting and performance analysis in Linux. This includes dynamic tracing scripts with SystemTap both for system calls and for userspace function tracing.

PyLatencyMap

PyLatencyMap is a tool for heat map visualization on the CLI. It is integrated with scrips to collect and visualize I/O latency heat maps from various sources, including SystemTap, DTrace, Oracle wait events, NetApp filers, trace files.

PerfSheet4

PerfSheet4 is a tool for performance troubleshooting of Oracle databases. Query and visualize Oracle AWR data using pivot charts.

Stack_Profiling

Tools and scripts for stack profiling: Userspace, Kernel, OS state and optionally Oracle wait

PerfSheet.js

PerfSheet.js is a tool for Oracle RDBMS performance troubleshooting. Use it to extract and visualize Oracle AWR time series data in the browser using JavaScript and dynamic pivot charts.

OraLatencyMap

OraLatencyMap is a performance widget running on SQL*plus (Oracle's CLI) to collect and visualize latency histograms for Oracle wait events using heat maps.