var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Clarification on the way how triggers are executed
I have written some triggers on database,
Triggers were written based on tables,
each table has 2 types of trigger, insert and update trigger..
acutally its related to data manipulation..
Meaning i have a audit table which records each data which is updated or inserted..
Its used for some monitoring purpose and statistics generation..
So this is the situation..
Lets say the trigger has 17 lines of code, and two users caused the trigger to be executed..
Just assume in the backgroud this happens
Trigger is executing for User1 and then before the trigger finish executing, User2 caused the same trigger to be executed,
So my question is will it process the trigger one by one or it will stop half way and start processing for user2?
I hope you guys get my point..thanks in advance..
Trigger which fires will come to its end.
Hi Thanks for the reply..didnt really get you..
Originally Posted by Littlefoot
Meaning 1 trigger wont cause the other one to stop processing even if its fired at the same time? No Interuption/half way processing?
As far as I know, second trigger will not stop or interrupt first one from processing.
Triggers will run in parallel and will be independent of each other.
Oracle is designed to run for thousands of users all executing stuff in parallel, as such they have designed virtually everything to run well even when users are contending for the same resource.