What % buffer hits are you getting (not since DB start. Take some samples over the next couple of hours)?
I use to see 99% before changing -B value and now it is showing 100%. please suggest me if you find out way to improve performance.
Event Total Per Sec Event Total Per Sec
Commits 17442888 60.5 Undos 55057 0.2
Record Updates 10355100 35.9 Record Reads 40358042921 139915.9
Record Creates 3427494 11.9 Record Deletes 2318737 8.0
DB Writes 1945469 6.7 DB Reads 373862769 1296.1
BI Writes 1082985 3.8 BI Reads 190851 0.7
AI Writes 783880 2.7
Record Locks 141982333 492.2 Record Waits 602 0.00
Checkpoints 701 0.00 Buffs Flushed 8289 0.0
Rec Lock Waits 0 % BI Buf Waits 0 % AI Buf Waits 0 %
Writes by APW 99 % Writes by BIW 52 % Writes by AIW 91 %
Buffer Hits 100 %
DB Size 122 GB BI Size 5468 MB AI Size 9776 K
FR chain 10707 blocks RM chain 895011 blocks
Shared Memory 2079M Segments 1
4 Servers, 369 Users (368 Local, 1 Remote, 3 Batch),5 Apws