AWR report evaluation [message #457048] |
Thu, 20 May 2010 21:49 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shrinika
Messages: 306 Registered: April 2008
|
Senior Member |
|
|
Hello, my DB is oracle10g.
I have AWR report comparision for two different days. I want to find the below things.
1. Which day has better performance?
2. What are the top two findings on the report.
I attached the report.
Here are my answer. Please correct me if i am wrong...
1. Which day has better performance?
Second day has higer load. Since redosize is showing
very high.
2. What are the top two findings on the report.
a) Compared to two days, first day, little bit more I/0 wait for single block read.
b) Compared to two days, 2nd day, it takes higher CPU.
However, which day is best compared to two days? Any input is
highy appreciated.
[Updated on: Thu, 20 May 2010 22:05] Report message to a moderator
|
|
|
|
Re: AWR report evaluation [message #457056 is a reply to message #457048] |
Thu, 20 May 2010 23:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shrinika
Messages: 306 Registered: April 2008
|
Senior Member |
|
|
Sorry. It took me a while to convert from html to pdf.
Here i attached.
OS is linux .
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
SQL>
Please let me know your thoughts.
-
Attachment: test.pdf
(Size: 248.95KB, Downloaded 3025 times)
[Updated on: Thu, 20 May 2010 23:08] Report message to a moderator
|
|
|
|
|
|