I have a recently released 10 000 user analytical application that is suffering from performance issues because of excessive amount of transactions. Apart from re writing many of the SQLs in the application for better performance we are also on top down approach where we are adding more volumes and tweeks to memory etc. An Oracle specialist redesigned our sever from single tablespace with 2 volumes to 2 tablespaces with 4 volumes where the indexes will have their own volume and tablespace. Each volume is a separate disk array so they do not compete for IO.
We have executed this change in development env and we are about to move into acceptance but before paying for the change the business would like to see measurable gains.
Where in the AWR report can I make comparisons to measure such data on the before and after the change is executed?