Hi All,
There is a sudden increase in Buffer gets in the query , It is a select query . It runs on all days but on Mondays (on most times ) it gets high buffer gets . I have listed the parameter values of my query
Total exec Elapsed time (Secs) Elap per Exec Total Disc Reads Total_buffer Gets Total Rows Processed CPU Time (Secs) IO Wait (secs)
40 14839.5 370.89 1167 2296819181 37806 14801.6 1.5
22 10198.7 462.67 7587 1650742859 27605 10148.2 2.3
12 4529.5 378.29 3093 707734448 11803 4528.5 1.8
8 3717.4 464.67 325 612653675 10145 3709.8 0.5
10 3665.1 365.51 691 599499048 9932 3644.4 1
18 305.9 16.99 1366 105895121 36422 303 1.3
Is this due to session level or on query level ? Why Buffer gets suddenly increased. There is a case where Total Rows processed is high yet it have less CPU time and Total Buffer gets.What could be the reason