Home » RDBMS Server » Performance Tuning » AWR REPORT
AWR REPORT [message #269946] Tue, 25 September 2007 03:53 Go to next message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
Buffer Cache: 784M
Shared Pool Size: 1,248M
Std Block Size: 8K
Log Buffer: 14,400K

Load Profile: per sec per tran
Redo size: 52,571.37 4,299.44
Logical reads: 16,461.06 1,346.23

Instance Efficiency Percentages (Target 100%)
all r almost 100%

Shared Pool Statistics
Memory Usage %: 93.07
% SQL with executions>1: 95.34
% Memory for SQL w/exec>1: 89.75

Top 5 Timed Events
CPU time 1,340 96.4
db file sequential read 68,013 42 1 3.1 User I/O
log file sync 22,168 24 1 1.7 Commit
log file parallel write 22,581 20 1 1.4 System I/O
db file parallel write 15,914 10 1 .7 System I/O

DATABASE IS SLOW??
can any1 give any suggesion??
Re: AWR REPORT [message #269950 is a reply to message #269946] Tue, 25 September 2007 03:57 Go to previous messageGo to next message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
I m using oracle 10g R2 and sun solaries OS.
Re: AWR REPORT [message #269953 is a reply to message #269946] Tue, 25 September 2007 04:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Keep on generating AWR report.

Regards
Michel
Re: AWR REPORT [message #269958 is a reply to message #269946] Tue, 25 September 2007 04:28 Go to previous messageGo to next message
tanmoy1048
Messages: 133
Registered: June 2007
Senior Member
thanx,but I dont understand. this report duration is 30 min. I have generated another 1.its almost same.
Re: AWR REPORT [message #269966 is a reply to message #269958] Tue, 25 September 2007 04:48 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Two useful links:
OraFAQ Forum Guide
How to Identify Performance Problem and Bottleneck

Regards
Michel
Previous Topic: I have one problem with snapshot date
Next Topic: Increase the redo log buffer: a couple of questions
Goto Forum:
  


Current Time: Thu Dec 08 23:56:31 CST 2016

Total time taken to generate the page: 0.11686 seconds