TKPROF Analyzer

TKPROF Analyzer processes Oracle TKPROF trace output to produce a structured performance report. It reads the raw text, identifies each SQL statement by its identifier, and computes key timing and I/O metrics. By normalizing input across Oracle versions, it ensures comparability and repeatable results. The tool highlights total elapsed time, CPU time, physical and logical reads, executions, and wait-event counts, presenting this data in ranked form to reveal the most impactful statements.\n\nCore workflow centers on aggregation and interpretation. It groups data by SQL_ID, sums metrics, and calculates a per-statement contribution to overall latency. Optional filters allow focusing on a particular schema, user, or time window. Advanced capabilities include plan-change detection, wait-event categorization, and export options (CSV, JSON) for offline analysis or incident reports.\n\nDistinct value arises from handling diverse TKPROF formats, providing robust error handling for incomplete traces, and delivering outputs that enable quick tuning decisions. Use cases include post-trace analysis after a performance run, comparative investigations across releases, and targeted referrals for index or join strategy changes. The tool is designed for DBAs and developers who need precise, actionable data without manual parsing.\n\nOutputs are export-ready and designed for collaboration: a top-SQL list, per-SQL details, plan-change notes, and optional charts or data exports. This supports incident analysis, performance reviews, and knowledge sharing across teams.