Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
AIX Tablespace IO waits by Avg BUfWt and Buffer Waits Total
Sorted by Avg Buf Wt(ms) DESC
------------------------------
Tablespace Reads AvReads/s AvRd(ms) AvBlks/Rd Writes AvWrites/s BufferWaits AvBufWt(ms)
ADSB_DATA02 2,822,748 5 5.21 1.26 1,151,714 2 37 32.7
ADSA_DATA02 4,783,131 8 6.38 1.26 2,130,339 4 134 31.72
ADSA_DATA05 728,786 1 113.18 28.65 15,453 0 333 30.84
ADSA_DATA01 229,664 0 523.98 56.01 245 0 52 30.77
ADSB_DATA05 276,904 0 72.41 9.77 6,745 0 266 30.75
Sorted by Buffer Waits Desc
---------------------------
Tablespace Reads AvReads/s AvRd(ms) AvBlks/Rd Writes AvWrites/s BufferWaits AvBufWt(ms)
TEMP 15,745,815 28 40.42 16.43 2,314,269 4 122,302 5.88
ADSA_INDEX04 6,801,097 12 19.04 1.43 393,554 1 11,054 22.05
UNDOTBS1 122,325 0 1335.63 1 707,662 1 10,724 18.51
ADSA_INDEX05 2,390,061 4 32.17 1.63 1,193,698 2 10,615 21.22
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.