Database Tuning (MOSC)

MOSC Banner

cursor_sharing=force isn't working

in Database Tuning (MOSC) 8 commentsAnswered ✓

I connect as DBA

I issue the command

ALTER SYSTEM SET cursor_sharing=force;

show parameter cursor_sharing

cursor_sharing            string   FORCE


Now I connect as the application user and run the query

select distinct T1.id,T1.state_name,T1.date_open,T1.assignee_curr,T1.dbid from ticket T1,access_control T10 where T1.case_data_access = T10.dbid and (T1.dbid <> 0 and (T1.id like '%PCCM10182079%')) and (

((T1.dbid = 0)

 OR (T10.dbid in (select parent_dbid from parent_child_links where parent_fielddef_id = 16780649 and child_dbid in (225978364,33554720,226324081,313827662,226324086,98599661,98599814,204455296,90775885,33554433)))

)) order by T1.id ASC;


Toad Monitor Sessions shows the original SQL.

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