Oracle Database Discussions

Hi ....

is there any documentation of AWR and ASH reports so that the report is studied in detail ...

For an example

IN ASH report

If you Take Section TOP SQL with TOP Events section ...

there are number of columns such as SQLID , Planhash, Sampled # of Executions , % Activity , Event , Top Row Source, SQL TEXT

Here this column Sampled # of Executions has number of times that SQL has been executed ... right ...???
and another column Top Row Source says either its TABLE ACCESS - FULL or any group by clause etc etc

From the above example just like that i want to study AWR and ASH in detail with every section of the report

CHeers...