Oracle and cursor_sharing

(K Buttress) #1

Wondering if anyone using Matrix with Oracle has had any issues with changing the cursor_sharing state from shared to forced.


We attempted this today and found that as soon as it was done, we received an error.





—>Start Error

DB Type : oci8



[ASSERT EXCEPTION] DB Error: no such fieldSELECT COUNT(*)

FROM sq_ast_lnk_tree t INNER JOIN sq_ast_lnk l ON t.linkid = l.linkid WHERE l.minorid = '14206'

AND t.treeid NOT LIKE (SELECT "(T.TREEID||'%')" FROM (SELECT rownum as linenum, "(T.TREEID||'%')" FROM (SELECT (t.treeid || '%')

FROM sq_ast_lnk_tree t

INNER JOIN sq_ast_lnk l ON t.linkid = l.linkid WHERE l.minorid = '10') WHERE rownum = 1) [nativecode=ORA-00904: "(T.TREEID||'%')": invalid identifier] (LINE 3650 IN /app115/matrix/mysource_matrix/core/include/asset_manager.inc) [SYS0270]



—>End Error



thanks



kyle

(Avi Miller) #2

Is there a particular reason why you changed the cursor sharing state?

(K Buttress) #3

We are hoping that it would improve the performance, and reduce contention within Oracle. But after our little experiment it looks as though the forcing of literals to bind variables is not as good a solution as we had hoped.