Yes, Oracle8i does use the entire text of each SQL statement (or the entire name of library cache objects in general) to compute the hash values used for storing and locating objects in the library cache. However, this has been true since release 7.2.3. Between 7.1.6 and 7.2.2 Oracle used the first and last 64 bytes. Previously, it was just the first and last 32 bytes.

Can you confirm the formula that Oracle uses for SQL parsing matching? I have read that: Oracle7 uses the first 200 characters of a SQL statement. Oracle8 uses the first 100 and last 100 characters. Oracle8i uses the whole statement. Are these statements accurate?