parse calls

All,

    I'm curious why I'm getting a reparse for every execution in the following scenario (this is a simplified example of a real problem):

SQL> select * from dual;

D
-

X

SQL> select * from dual;

D
-

X

SQL> select * from dual;

D
-

X

SQL> select parse_calls, executions from v$sqlarea where sql_text like 'select * from dual%';

PARSE_CALLS EXECUTIONS
----------- ----------

          3 3

I have cursor_sharing=FORCE and session_cached_cursors=20

TIA Received on Wed Aug 10 2005 - 21:48:50 CDT