Database Administration (MOSC)

MOSC Banner

cursor_sharing = exact change to cursor_sharing = similar`

edited Jul 22, 2010 10:52AM in Database Administration (MOSC) 10 commentsAnswered
hi all,

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 =                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center