var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Awr Report
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??
I m using oracle 10g R2 and sun solaries OS.
What makes you think anyone could come with suggestion for such a brief report ? We would at least need the whole report and even so not so sure..
Define 'SLOW'. (i.e. slow, compared to what? Is it slower than an identically set up database? Is it slower than it was yesterday? Is it slower than you would like it to be?).
90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.