I am wondering if there is any thing such as AWR report which can give a generic picture of events happening in the database causing performance issues
or any kind of snapshots for particular time period
Statistics from table are generally a summarized detail since cluster startup