Open cursor issue
430487Sep 1 2009 — edited Sep 3 2009We recently started getting our open cursors maxing out in a test environment...
The SQL that's chewing up the number of cursors is:
SELECT s.sys_nc_oid$
FROM xdb.xdb$schema s
WHERE s.xmldata.schema_url = :1
AND BITAND (TO_NUMBER (RAWTOHEX (s.xmldata.flags), 'XXXXXXXX'), 16) = 16
This is NOT sql our pl/sql package is executing. It's simply either inserting into a table that has an XMLType column or - updating that same table. For whatever reason - Oracle is running the above sql (multiple times) and chewing up the number of allowable open cursors.
Any insight is appreciated.