External Table

Discussion on how to create sql_patch with force_match=true in Oracle 11g and related topics. SQL patches have recently saved the day for ...

V$EVENT_HISTOGRAM_METRIC does not exist (at least up to 11.2.0.3) however it could be handy! The idea is combine the detailed information f...

Topic: GV$ views of the ' metrics family ' and how they can help in tuning + links to scripts I use. Oracle has plenty of instrum...

Case: This is part 2/2 of a performance investigation. In the previous part we have seen how the sudden increase of single block read laten...

This is a performance investigation of Oracle DB and interaction with storage.  Case: DB operations are slow during backup. The system...

This is the first entry of this blog. Just to see if all works and to tune the layout. The blog will cover Oracle and databases. In particul...