AWR report - 1hr or 8hr ??
hello all,
We are having a little confusing about our AWR reports. We have a dba team of 2 guys. And We are trying to tune the database. But I suggested to take the awr report of an hour interval. But the other guy goes with 6- 8 hours of awr report. Also like yestreday he took a awr report of 24 hours, and we started looking at thing from our 24hours snapshot, watever came up at the top. Altough i cant argue with him, as he is my lead. But what is the ideal time for these report to look at ? As i think 8 hours is a little too much. When you open up a TAR with oracle they ususaly ask for an hour of ur AWR reports. Please suggest which is better and WHY ??
Also, i wanted to know if we can find out how many TOTAL transaction happen during that timeframe of the AWR report or how much load was on the system for that AWR snapshot. What i am asking is what to look for the total transation. THANKS