cursor_sharing=force isn't working
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.