Top Write Activity Tables
- Another graph in the left bottom right section, shows the top 10 tables involved maximum write activity.
- The activity usually includes count of disk blocks written during a query execution.
- A high write count indicates the usage of the table being high and strategy deficiency in storing data in the table.
- You may want to consider partitioning the table to reduce IO load on the DB system so that queries read lesser disk blocks and hence lesser IO thrashing.
