In answer to a question a few weeks ago, I mentioned that the number of soft
parses is not merely the complement of hard parses if the session cursor cache
facility is in use. As a follow-up to that, I have now updated the Oracle8
version of the session_cursor_cache.sql script on the Ixora website to also give
the percentage breakdown of parse calls into

  * session cursor cache hits  = no library cache access required
  * shared cursor cache hits   = library cache hits   = soft parses
  * shared cursor cache misses = library cache misses = hard parses

I hope you find it helpful.