External Table

I am looking forward to participating again to the  UKOUG annual conference (and also to attend the Sunday's OakTable event). This is f...

Topic: A review of the command-line monitoring scripts that I currently use for Oracle. Note:  last updated in June 2015. Download links:...

Scope:  New features and improvements on the SQL (cost-based) execution engine are great. However sometimes the need comes to turn some of t...

Introduction : this post  is about the use of recursive subquery factoring (recursive common table expressions) in Oracle to find numerical ...

Topic: An investigation of a few details of the implementation of listeners in 11gR2, including the configuration of listener.ora in RAC an...

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