SQL Processing
The following steps show how Oracle processes SQL Statement is passed to Oracle for processing Before it is placed in the library cache, a hash value is computed that represent s a number of characteristics of the SQL. Oracle compares the computed hash value against those values in a hash table where it maintains for …