Re: Oracle wait interface..bug or expected behavior?

> 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

Firstly, it is not a function of the wait interface to log these details. AWR has some issues with double counting when PL/SQL is used. The *best and most* accurate way of determining buffer gets is to use a 10046 trace (even at level 1 a.k.a. SQL_TRACE = TRUE).

-- 
John Kanagaraj <><
http://www.linkedin.com/in/johnkanagaraj
http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!)
** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **
--
http://www.freelists.org/webpage/oracle-l