Hi,

I'm just having trouble understanding this. What are the real
differences between the ASHRPT, ADDMRPT and AWR? I am not finding any
documentation on the differences, or even how to read them with
regards to some of the items and what they mean?

log file parallel write -- ??
log file sync -- ??
null event -- ??

I do not find any Oracle documentation on this no matter where I
look. Can anyone just give me some info?

Thanks!

On Mar 14, 9:12*am, The Magnet <a... (AT) unsu (DOT) com> wrote:
Here's a white paper that may help you with some basic differences:
http://www.oracle.com/us/products/da...twp-066400.pdf
Here's an example of ADDM: http://oracledoug.com/serendipity/in...Love-ADDM.html
Of course, the performance tuning manual has all the basics, chapter 5
in the 11.2 guide.

See the performance tuning manual, it gets you started looking at each
of those. Just type in each term in the navigation search screen and
follow the links!

Naturally the manual is a bit generic and can be completely misleading
(as can the advisors and any auto-tuning tools), so searching google
comes up with case studies to walk you through what people have seen.

There're also books about performance tuning, though I haven't looked
at the recent basic books. Others have made recommendations you can
find.

jg
--
@home.com is bogus.
brouhaha http://www.informationweek.com/news/...Section=N ews