Re: AWR

From: joel garry <joel-garry_at_home.com>
Date: Mon, 14 Mar 2011 11:47:10 -0700 (PDT)
Message-ID: <cf7abef6-eb2d-414d-b092-e3e5dd094749_at_o30g2000pra.googlegroups.com>

On Mar 14, 9:12�am, The Magnet <a..._at_unsu.com> wrote:
> 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?

Here's a white paper that may help you with some basic differences: http://www.oracle.com/us/products/database/self-managing-database-twp-066400.pdf Here's an example of ADDM: http://oracledoug.com/serendipity/index.php?/archives/1504-I-Love-ADDM.html Of course, the performance tuning manual has all the basics, chapter 5 in the 11.2 guide.

>
> 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?

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

--
_at_home.com is bogus.
brouhaha http://www.informationweek.com/news/software/info_management/showArticle.jhtml?articleID=229300064&subSection=News

Received on Mon Mar 14 2011 - 13:47:10 CDT