Buffer gets in v$sql and dba_hist_sqlstat

From: Petr Novak <Petr.Novak_at_trivadis.com>
Date: Wed, 3 Jun 2015 13:12:34 +0000
Message-ID: <09011014EB621E4CBC2536B62A1B6407C893498E_at_smxc002.trivadis.com>


insert statement, trigger on table calls 2 stored procedures and inserts rows in other tables.

On v$sql and dba_hist_sqlstat show same number buffer_gets/execution - 400. On v$sql shows 20 and dba_hist_sqlstat 400 buffer gets/execution.

I anybody aware about some bug/difference in accounting (recursive ?) sql in 11.2. between v$sql and dba_hist_sqlstat ?

Best Regards,
http://www.freelists.org/webpage/oracle-l Received on Wed Jun 03 2015 - 15:12:34 CEST

Original text of this message