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 →

Exadata Roadmap Preview

Last week, Andrew Mendelsohn gave a talk at the Enkitec Extreme Exadata Expo ("E4") run in Texas by those excellent guys at Enkitec. Andrew is the SVP of Oracle's Database Server Technologies group, so it's fair to say he has his finger on the pulse of the Oracle roadmap for Exadata. Big thanks to Frits Hoogland … Continue reading Exadata Roadmap Preview →

Database Virtualization Part 2 – Flash Makes The Difference

In part one of this article I talked about Database Virtualisation and how I believe that it is the next trend in our industry. Databases - particularly Oracle databases - have held out against the rise of virtualisation for a long time, but as virtualisation products have matured and the drive to consumerise and consolidate … Continue reading Database Virtualization Part 2 – Flash Makes The Difference →