Tag: tag

DBA_HIST_ACTIVE_SESS_HISTORY Oracle ASH analysis dashboard showing SQL performance and wait events

DBA_HIST_ACTIVE_SESS_HISTORY: Complete Guide to Oracle ASH Analysis

Posted on by sanjeeva

Introduction Have you ever been asked to explain why your Oracle database was slow last Tuesday at 2:30 PM? Or needed to identify which SQL statements were causing CPU spikes during last night’s batch run? This is where DBA_HIST_ACTIVE_SESS_HISTORY becomes your most powerful diagnostic tool. Recently, we faced a production issue where users reported intermittent Read more about DBA_HIST_ACTIVE_SESS_HISTORY: Complete Guide to Oracle ASH Analysis[…]

DBA_HIST_SEG_STAT Oracle database growth analysis dashboard showing segment statistics and capacity trends

DBA_HIST_SEG_STAT: SQL Queries to Track Oracle Growth

Posted on by sanjeeva

Introduction Have you ever needed to analyze Oracle database growth trends but found yourself limited by current snapshot data? In real production environments, tracking database growth trends is a critical aspect of DBA life because this allows businesses not only to foresee the real position in terms of existing hardware but also enables planning future Read more about DBA_HIST_SEG_STAT: SQL Queries to Track Oracle Growth[…]