Indirect use of cursors

Hi all,

I've been asked to check whether increased cursor usage in an in-house 9iR1 database has been caused by the recent introduction of some PL/SQL triggers.

The triggers typically fire on insert and/or update, and they don't explicitly use cursors *at all*; they select, update, insert, return an error status and so on, but there's zero use of cursors as I understand them - no DECLARE CURSOR statements, for example.

According to the output of a diagnostic script, some of the tables associated with the triggers are grabbing (and more importantly, not releasing, cursors). Is it possible that the triggers can be to blame? I plan to run some processes with and without the triggers activated, and to take a look at v$open_cursor, but I'd be interested to know if anyone has encountered a similar situation already...

TIA
Nick Received on Mon Oct 31 2005 - 07:40:59 CST