Links

▼
Wednesday, September 26, 2012

Command-Line DBA Scripts

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

How to Turn Off Adaptive Cursor Sharing, Cardinality Feedback and Serial Direct Read

›
Scope:  New features and improvements on the SQL (cost-based) execution engine are great. However sometimes the need comes to turn some of t...
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 ...