cursor_sharing = exact change to cursor_sharing = similar`
i am using oracle 10g version 10.2.0.4 i am new in my organization i see that here they are using parameter optimizer_mode = RULE and i was shoked.....................! , then i saw that cursor_sharing = exact ..
and i run these quries
select sql_text from v$sqlarea where executions = 1 order by upper(sql_text);
select sql_text,parse_calls,executions from v$sqlarea order by parse_calls;
i saw thousands of quries
SELECT ROWID,POLICY_NO FROM Policy WHERE policy_no =
SELECT ROWID,POLICY_NO FROM Policy WHERE policy_no =
SELECT ROWID,POLICY_NO FROM Policy WHERE policy_no =
SELECT ROWID,POLICY_NO FROM Policy WHERE policy_no =