Search

Top 60 Oracle Blogs

Recent comments

Why does even a small difference in SQL text cause a hard parse?

I just replied to an Oracle Forum Thread about why does even a small difference in SQL statement text cause it to be hard parsed and loaded as a different cursor. The reason is actually very simple – and I’m posting it into my blog too:

 The reason why a statement with even a minor difference in text is parsed as a separate cursor is due how Oracle looks up statements from library cache.