| AWR REPORT [message #269946] |
Tue, 25 September 2007 03:53  |
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??
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
