As part of my role at Violin I spend a lot of time profiling customer's databases to see how their performance varies over time. The easiest way to do this (since I often don't have remote access) is to ask for lots of AWR reports. One single report covering a large span of time is … Continue reading AWR Generator
Tag: oracle scripts
Querying DBA_HIST_SNAPSHOT and DBA_HIST_SYSSTAT
Why is it so hard in Oracle to get a decent answer to the question of how many seconds elapsed between two timestamps? I'm looking at DBA_HIST_SNAPSHOT and wondering how many seconds each snapshot spans, because later on I want to use this to generate metrics like Redo Size per Second, etc. SQL> desc dba_hist_snapshot … Continue reading Querying DBA_HIST_SNAPSHOT and DBA_HIST_SYSSTAT
flashdba 