andrej_at_kintana.com (Andrej Gabara) wrote in
news:11a3a163.0302231712.4369046f_at_posting.google.com:
> "Jim Kennedy" wrote:
>> use triggers and have the trigger submit a job to do the notification
>> see thr dbms_job package. The job will ONLY run if the transaction
>> is committed - which is what you wanted. (much simpler and a lot
>> more efficient than the log sniffing idea)
>> Jim
>
> Looks like Oracle polls the job queue in regular intervals.
AFAIK, the interval can be set as low as 1 second; but
I'm not sure how badly that would affect CPU consumption.
Received on Sun Feb 23 2003 - 19:15:47 CST
