Oracle’s 32 Character Limit in Generating Histograms

Upon Oracle’s release of 11g and noticeably with 11g Release 2, Oracle’s functionality is pretty rock solid.  What I considered the most obvious weaknesses of the Oracle database engine are now resolved.  Namely, Adaptive Cursor Sharing resolves the problem of bind peeking, and SQL Plan Management resolves plan stability issues.  But one limitation still remaining…

Read more