11g, 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 database?
Is there an estimate or recommended size for SGA/Memory for our database with 100 concurrent users?
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