Statspack and AWR Report using Toad
Once you start the toad statspack Browser you need to select
the beginning and ending snapshot of database performance statistics and then
offers graphical trending and time series analysis based on those stats. It
also contains advisories. When you select starting and ending snaps then
‘advice’ tab will give some information about the top wait event during the
selected interval. Another way to display the advice is to double-click blue
underlined waits in the top waits grid. Check the below figure to clear the
concept:
