Oracle wait interface..bug or expected behavior?
- From: amit bansal <amit.bansal82@xxxxxxxxx>
- To: oracle-l L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 1 Sep 2010 20:35:55 +0530
Need to check if this is expected behavior or bug with wait interface.
Whenever application inserts data into table, trigger is fired which runs a
merge statement and then runs a update statement on another table.
Now when I look at awr report, I see the insert statement has high number of
buffer gets/execution and consumes 61% of Db time.(Looking at Sql by buffer
gets). Next 2 sql are merge and update statement whose sum of buffer gets
equals to the insert statement
i.e if Insert statement had 36K buffer gets, merge+update statement has
total buffer gets as 36K. (though they have more executions)
My question is that if there is a insert statement and there are triggers on
it, will Oracle wait interface show the buffer gets statistics for triggers
under initial insert statement . This is 10.2.0.4 database on Linux x86_64
Regards
Amit
http://askdba.org/weblog/
Other related posts:
