External Table

Introduction: Purging cursors from the library cache is a useful technique to keep handy for troubleshooting. Oracle has introduced a proce...

Topic: a discussion on how to use Kerberos authentication  and of proxy users in Oracle. This aimed at providing an alternative to the cla...

Topic: Discussion and implementation of a method for finding hash collisions for sql_id and SQL signature in Oracle. Introduction: MD5...

Topic: A discussion on how Oracle computes SQL signature using MD5 hashing and on how SQL text is normalized before computing SQL signature...

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...