Iteration Read Date Read Time BI Read BI Write Checkpoint Buffer Flush Tran Commit DB Access DB Read DB Write Records Created Records Deleted Records Read Records Updated Record Waits Records Committed
1 11/02/15 12:20:04 43 6829 2 0 42446 76920683 524206 9060 17910 6319 30722934 35686 1 0
2 11/02/15 12:25:15 11 6296 2 0 11473 83926694 433032 9021 25623 5548 30081785 33902 0 0
3 11/02/15 12:30:28 17 8559 2 0 5651 102418667 444331 8905 35725 6349 37253832 44815 1 0
4 11/02/15 12:35:39 4 6574 1 0 5185 94768711 399434 7142 22559 6738 34924147 32504 0 0
5 11/02/15 12:40:50 49 5950 2 0 4328 68424312 258407 5745 20707 6369 26956057 25757 1 0
6 11/02/15 12:46:02 5 7083 1 0 7274 90813472 245563 6340 25761 6388 35312684 31932 6 0
7 11/02/15 12:51:15 7 5425 2 0 5102 61743179 284143 6748 18288 6432 26379733 22427 2 0
8 11/02/15 12:56:26 7 5466 1 0 4656 46298824 226568 5146 18682 6160 19003023 24447 0 0
9 11/02/15 13:01:37 3 6239 1 0 5007 40719091 306658 7515 23513 6223 16325950 29656 0 0
10 11/02/15 13:06:48 11 4575 2 0 5967 41924760 224671 6276 14807 4354 17020137 24578 5 0
11 11/02/15 13:12:00 3 4475 1 0 4547 46610572 268941 5162 14098 3159 18434522 27180 10 0
12 11/02/15 13:17:11 3 5446 1 0 6085 47087756 322420 5353 17907 6388 18509296 24307 0 0
Total
Total BI writes 4225686
BIW BI writes 4039525
Records written 334568K
Bytes written 32471123K
Total BI Reads 3277453
Records read 1978362
Bytes read 178754K
Clusters closed 995
Busy buffer waits 2314
Empty buffer waits 3791
Log force waits 0
Log force writes 0
Partial writes 153833
Input buffer hits 817974
Output buffer hits 1300806
Mod buffer hits 438397
BO buffer hits 711029
How often are you checkpointing during busy periods?
- usually once or twice - we upped BI Cluster Size because we were on default values with huge checkpoint values and buffer flushes at checkpoint.
The calculation is similar to -B. Number of buffers times block size. If BI block size is 16 KB and -bibufs is 200 then the hit is 3.1 MB. If you can't afford that you have bigger issues.When you say a "small" RAM hit for that, what are we talking?
You can also see -bibufs and -aibufs and block sizes in promon R&D 1 9 and 1 10.Unfortunately I don't have the log file from the last DB start anymore.
To change AI block size you first need to disable replication and disable AI. Then reseed replication.If I change AI Block size on REPL source, do I also need to do the same on the REPL Target?