Hello, This is the buffer gets section of the statspack report. The statspack snapshots were taken in a 15 minute time interval. Does this mean that the query was executed 418 times in 15 minutes? The reason I am asking is another application related query in the same report was executed 40000 times. I am not sure why it is executed at such a rate. Thanks ...
SQL ordered by Gets for DB: DBDP Instance: DBDP Snaps: 31 -34
-> End Buffer Gets Threshold: 10000
-> Note that resources reported for PL/SQL includes the resources used by
all SQL statements called within the PL/SQL code. As individual SQL
statements are also reported, it is possible and valid for the summed
total % to exceed 100
CPU Elapsd
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
981,994 4,976 197.3 14.0 231.25 392.21 4046437314
Module: JDBC Thin Client
SELECT ....
SQL ordered by Gets for DB: DBDP Instance: DBDP Snaps: 31 -34
-> End Buffer Gets Threshold: 10000
-> Note that resources reported for PL/SQL includes the resources used by
all SQL statements called within the PL/SQL code. As individual SQL
statements are also reported, it is possible and valid for the summed
total % to exceed 100
CPU Elapsd
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
981,994 4,976 197.3 14.0 231.25 392.21 4046437314
Module: JDBC Thin Client
SELECT ....