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

.

Relevant Pages

  • Re: Triggers, performance, and distributed processing
    ... David, ... down to the question, "where is the bottleneck, in the triggers or the SPs?" ... We do often resort to using cursors in our triggers, ... > you'll have a difficult time getting bad data into a database that uses ...
    (microsoft.public.sqlserver.programming)
  • Re: Triggers, performance, and distributed processing
    ... David, ... down to the question, "where is the bottleneck, in the triggers or the SPs?" ... We do often resort to using cursors in our triggers, ... > you'll have a difficult time getting bad data into a database that uses ...
    (microsoft.public.sqlserver.server)
  • Re: Triggers, performance, and distributed processing
    ... > Yes, we really like the concept of triggers, and are reluctant to use ... > alternatives to cursors. ... the data is an exact copy of production. ... David G. ...
    (microsoft.public.sqlserver.server)
  • Re: triggers
    ... >> is it ok to code triggers? ... overhead like cursors do? ... donw by the host program, ... Avoid triggers when you can in favor of DRI actions. ...
    (microsoft.public.sqlserver.programming)
  • Re: Triggers, performance, and distributed processing
    ... > Yes, we really like the concept of triggers, and are reluctant to use ... > alternatives to cursors. ... the data is an exact copy of production. ... David G. ...
    (microsoft.public.sqlserver.programming)