Hello netland,
I have some tables that are updated infrequently (about every five
minutes or so). When an update is done some external C-programs
have to be triggered. I've solved this using the dbms_alert package,
but I am considering using the dbms_pipe package instead.
Does anyone have any opinions/recommendations/experiences concerning the
dbms_alert package and the dbms_pipe package? I'm using Oracle 7.0.16.
Are there any performance considerations to make (apart from the comments
about parallell mode etc in the dbmsalrt.sql file)?
What I am doing at the moment is something like this (using OCI):
A C-program generates data irregularly and writes this data to one or
more tables in the database. These tables have triggers on them, which
in turn "raise signals", ie does the following in PL/SQL:
...after insert or update or delete on the_table
begin
dbms_alert.signal('the_table_alert', 'a_table_alert');
end;
Other C-programs subscribe on these signals using dbms_alert.waitany(...).
Everything works, but sometimes it seems all tables get locked until
there is a commit from the first C-program.
