Tools, scripts and resources
KStackSampler - poor man's profiler for kernel stack trace profiling
for Linux. October 2015. See also the blog post: See also this blog
Linux Kernel Stack Profiling and Flam Graphs Applied to Oracle Investigations
ORA_KStackProfiler, Ptrace_Profiler - kernel and userspace stack tracing extended with OS process stace and optionally Oracle wait event details. See also:
Oracle Wait Events Investigated with Extended Stack Profiling and Flame Graphs
PyLatencyMap provides latency heat map visualization for the CLI. Use to
collect and visualize latency histograms from SystemTap, DTrace, Oracle
wait events, trace files, NetApp C-mode instrumentation. The tool is written in Python.
Current version: v1.2.3, July 2015.
PyLatencyMap is also available
See also this blog entry on PylatencyMap, this other entry on how to get started with PyLatencyMap and this entry on how to use PyLatencyMap and SystemTap to measure block I/O latency.
A tool for Oracle AWR analytics: data mining and
visualization using Excel. Current version: v3.7.2, February
2015 (last updated July 2015).
Linux_tracing_scripts: A collection of scripts for Linux OS dinamy
tracing and Oracle userspace tracing. Is a super set of the previously
Stap_scripts.zip. Last updated:
See additional details at the blog entries:
SystemTap into Oracle for Fun and Profit, Life of an Oracle I/O: Tracing Logical and Physical I/O with SystemTap, Diagnose High-Latency I/O Operations Using SystemTap.
A tool for collecting and displaying Oracle wait event latency
details using heatmaps, implemented for the CLI.
It is a SQL*Plus script, with a core written in PL/SQL. Current version: v1.2, March 2014.
See also: blog entry on OraLatencyMap and blog entry on OraLatencyMap v1.1
A collection of DBA scripts I use. Current version: June 2015. Includes top.sql, ash.sql and ehm.sql scripts. See also the description of the scripts at this blog entry.
Event Histogram Metric -This script
collects and displays latency histograms for Oracle wait events. Use for
exmaple to study I/O latency. Current version:
1.1 June 2015. First version,
1.0 (2012) at: Ehm.zip
|SQL_color_Mandelbrot.zip||How to colorize your SQL with an example of SQL how to add color to the SQL for representing the Mandelbrot set. Last updated August 2015. See also this blog entry.|
Event_sampler_latency_histogram.py, a script for Oracle performance
analysis: high frequency
sampling of X$KSLWH for latency studies of random IO.
Event_sampler_gather_IO_history.py: collects the history for the blocks read
into the cache using data from X$KSLWH.
See also the blog entry on event sampler.
A perl-based script to read and write single blocks from Oracle datafiles in ASM. See also blocg entry on testing lost writes.
See blog entry on hash-collisions-sql-signatures-and.html: hash_birthday.sql, hash_birthday_signature.sql, find_dup.sql, Hash_Collisions_Results.txt and scripts for parallel execution of the hash collisions search.
md5.sql and md5_with_chr0.sql scripts to compute md5 hashes and reproduce the calculations of hash_value and signature in Oracle. See blog entry on sql-signature-text-normalization-and.html
A collection of scripts for monitoring and troubleshooting from v$ views of the type 'metric', such as sysmetric, eventmetric, iometric.
See also: https://github.com/LucaCanali
Browse all files
Link to the main page.