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>
Hallo,
Date: Wed, 3 Jun 2015 13:12:34 +0000
Message-ID: <09011014EB621E4CBC2536B62A1B6407C893498E_at_smxc002.trivadis.com>
Hallo,
insert statement, trigger on table calls 2 stored procedures and inserts rows in other tables.
On 12.1.0.2 v$sql and dba_hist_sqlstat show same number buffer_gets/execution - 400. On 11.2.0.4 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,
Petr--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 03 2015 - 15:12:34 CEST