Re: Performance Question - trigger

cvonancken_at_orkand.com (Curtis VonAncken) wrote in message news:<b712ca72.0207300811.709a3ed6_at_posting.google.com>...
> Hey folks,
> I'm hoping someone can help me get a grasp on this. I have a package
> that runs several procedures to delete and then re-populate a table
> that one of our apps uses as an index of sorts. It's a rather complex
> set of procedures and the best I can get the time for them running is
> about 5 mins. That data contained in this table is directly impacted
> by the data two other tables. My first thought is to have trigger
> that will run on update or insert for the two tables.
>
> What I need to know is if say user A runs an update on table xxx (one
> of the two tables) and the tigger runs my set of procedures will this
> affect user A's performance? Note that user A has nothing to do with
> the table and app that trigger affects.
>
> Does the tigger run in the background or is it directly tied to that
> users transaction?
>
> Is there a better way that I should be doing this?
>
> sorry if I made this confusing...

Triggers run in the user session.
If business rules require an update on table xxx should fire related updates/inserts, then your assertion 'User A has nothing to do with it' is false.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Wed Jul 31 2002 - 09:08:49 CEST