That recursive stmt hasn't to be involved with the
stmt beneath. However, are you using private synonyms
or do you have a lot of tables and objects ?. Why
don't you look at gets and misses in the v$rowcache ?.
Are you suffering of row cache lock wait ?. Are you on
8.1.X ?, do you know the thing ab
I'm expereinceing a weird problem.
I have a tabl whihcis basically a collection of
counters (NAME VARCHAR2, COUNTER NUMBER). For various reasons that are
unimportant in this context the tables work by atempting an insert on (NAME, 1)
and if that fails they do an update COUNTER = COUNTER +!