Raunak's DBA Blog

sql_perf_analyzer.sh #!/bin/bash # Filename: sql_perf_analyzer.sh # Description: Intelligent SQL Performance Diagnostic Toolkit (Shell Wrapper) # Author: ChatGPT Toolkit for Oracle # === Setup Variables === SCRIPT_DIR=$(dirname "$0") SQL_DIR="$SCRIPT_DIR/sql" LOG_DIR="$SCRIPT_DIR/output/logs" REPORT_DIR="$SCRIPT_DIR/output/reports" DATE_TAG=$(date '+%Y%m%d_%H%M%S') LOG_FILE="$LOG_DIR/sql_perf_analysis_$DATE_TAG.log" mkdir -p "$LOG_DIR" "$REPORT_DIR" # === Prompt Inputs === echo "Enter SQL_ID to diagnose: " read SQL_ID echo "Enter GOOD timeframe (start time YYYY-MM-DD HH24:MI): " read GOOD_START echo "Enter GOOD timeframe (end time YYYY-MM-DD HH24:MI): " read GOOD_END echo "Enter BAD timeframe (start time YYYY-MM-DD HH24:MI): " read BAD_START echo "Enter BAD timeframe (end time YYYY-MM-DD HH24:MI): " read BAD_END echo "Output format? (1=Text, 2=HTML, 3=Bot...