Links

▼
Wednesday, July 18, 2012

Recursive Subquery Factoring, Oracle SQL and Physics

›
Introduction : this post  is about the use of recursive subquery factoring (recursive common table expressions) in Oracle to find numerical ...
Wednesday, July 11, 2012

Listener.ora and Oraagent in RAC 11gR2

›
Topic: An investigation of a few details of the implementation of listeners in 11gR2, including the configuration of listener.ora in RAC an...
3 comments:
Thursday, June 28, 2012

Purging Cursors From the Library Cache Using Full_hash_value

›
Introduction: Purging cursors from the library cache is a useful technique to keep handy for troubleshooting. Oracle has introduced a proce...
Thursday, June 21, 2012

Kerberos Authentication and Proxy Users

›
Topic: a discussion on how to use Kerberos authentication  and of proxy users in Oracle. This aimed at providing an alternative to the cla...
2 comments:
Monday, June 11, 2012

Hash Collisions in Oracle: SQL Signature and SQL_ID

›
Topic: Discussion and implementation of a method for finding hash collisions for sql_id and SQL signature in Oracle. Introduction: MD5...
Tuesday, June 5, 2012

SQL Signature, Text Normalization and MD5 Hash

›
Topic: A discussion on how Oracle computes SQL signature using MD5 hashing and on how SQL text is normalized before computing SQL signature...
Monday, May 21, 2012

SQL Patch and Force Match

›
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 ...
Monday, May 14, 2012

V$EVENT_HISTOGRAM_METRIC

›
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...
Monday, May 7, 2012

Performance Metrics Views

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

Of I/O Latency, Skew and Histograms 2/2

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