First page Back Continue Last page Graphics

…Shared Pool Reuse


Notes:

SQL statements need to be identical to be considered equivalent. Because of the different case used in the table name, the following statements are NOT identical:
SELECT ename, sal FROM emp WHERE deptno = 20;
SELECT ename, sal FROM EMP WHERE deptno = 20;
Not only do statements need to be match syntactically and character-by-character, they must be semantically the same. For example, the clause “FROM emp” could mean DAVE.EMP or PRODUCTION.EMP, depending on who is executing the query.
Using stored PL/SQL and bind variables will increase the likelihood of matching SQL because many sessions tend to execute the same procedures.