Skip to content

Instantly share code, notes, and snippets.

@christopherdtaylor1994

christopherdtaylor1994/gist:4001326

Created November 2, 2012 13:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save christopherdtaylor1994/4001326 to your computer and use it in GitHub Desktop.
Save christopherdtaylor1994/4001326 to your computer and use it in GitHub Desktop.
Download ZIP
AIX Tablespace IO waits by Avg BUfWt and Buffer Waits Total
Raw
gistfile1.txt
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