12c
Hi ALL,
Which portion in AWR report will show that SGA or memory allocation in our database is good, or enough, or correct?
Can AWR show which hour of the day was there peak usage in Memory/CPU in our EBS database?
Is there an estimate or recommended size for SGA/Memory for EBS R12?
WORKLOAD REPOSITORY report for
PROD | 157292119 | PROD | 1 | 24-Jun-19 05:06 | 11.1.0.7.0 | NO |
prod.oracle.com | Linux x86 64-bit | 8 | 8 | 2 | 38.38 |
Begin Snap: | 73141 | 24-Jul-19 01:00:20 | 305 | 23.9 |
End Snap: | 73142 | 24-Jul-19 02:00:22 | 303 | 24.5 |
Elapsed: | | 60.04 (mins) | | |
DB Time: | | 9.88 (mins) | | |
Report Summary
Cache Sizes
Buffer Cache: | 11,776M | 11,776M | Std Block Size: | 8K |
Shared Pool Size: | 3,200M | 3,200M | Log Buffer: | 58,728K |
Load Profile
DB Time(s): | 0.2 | 0.1 | 0.00 | 0.01 |
DB CPU(s): | 0.2 | 0.1 | 0.00 | 0.01 |
Redo size: | 14,286.5 | 5,654.5 | | |
Logical reads: | 18,178.0 | 7,194.7 | | |
Block changes: | 100.3 | 39.7 | | |
Physical reads: | 2.3 | 0.9 | | |
Physical writes: | 2.3 | 0.9 | | |
User calls: | 22.6 | 9.0 | | |
Parses: | 6.9 | 2.7 | | |
Hard parses: | 0.1 | 0.0 | | |
W/A MB processed: | 554,938.5 | 219,641.2 | | |
Logons: | 0.1 | 0.0 | | |
Executes: | 42.2 | 16.7 | | |
Rollbacks: | 1.5 | 0.6 | | |
Transactions: | 2.5 | | | |
Instance Efficiency Percentages (Target 100%)
Buffer Nowait %: | 100.00 | Redo NoWait %: | 100.00 |
Buffer Hit %: | 99.99 | In-memory Sort %: | 100.00 |
Library Hit %: | 97.10 | Soft Parse %: | 99.11 |
Execute to Parse %: | 83.66 | Latch Hit %: | 99.99 |
Parse CPU to Parse Elapsd %: | 0.01 | % Non-Parse CPU: | 99.86 |
Shared Pool Statistics
Memory Usage %: | 43.41 | 43.36 |
% SQL with executions>1: | 94.87 | 96.81 |
% Memory for SQL w/exec>1: | 95.18 | 97.49 |
Top 5 Timed Foreground Events
DB CPU | | 583 | | 98.41 | |
db file sequential read | 7,331 | 6 | 1 | 1.08 | User I/O |
log file sync | 2,853 | 2 | 1 | 0.37 | Commit |
local write wait | 594 | 1 | 1 | 0.10 | User I/O |
control file sequential read | 1,063 | 0 | 0 | 0.07 | System I/O |
Host CPU (CPUs: 8 Cores: 8 Sockets: 2)
Instance CPU
Memory Statistics
Host Mem (MB): | 39,299.7 | 39,299.7 |
SGA use (MB): | 15,360.0 | 15,360.0 |
PGA use (MB): | 1,906.2 | 1,906.6 |
% Host Mem used for SGA+PGA: | 43.93 | 43.93 |
Main Report
Please help...
Kind regards,
jc