Hi All,
My database version is 11.2.0.4
My OS version is SUSE Linux Enterprise Server 11 SP3
Physical RAM is 252 .
Please help me in understanding the below part of AWR.
| Begin Snap: | 284 | 25-Nov-15 00:00:13 | 490 | 134.2 |
| End Snap: | 311 | 26-Nov-15 03:00:57 | 486 | 142.0 |
| Elapsed: | | 1,620.74 (mins) | | |
| DB Time: | | 2,526.19 (mins) | | |
Report Summary
Load Profile
| Per Second | Per Transaction | Per Exec | Per Call |
|---|
| DB Time(s): | 1.6 | 0.1 | 0.00 | 0.00 |
| DB CPU(s): | 0.4 | 0.0 | 0.00 | 0.00 |
| Redo size (bytes): | 917,615.9 | 41,306.1 | | |
| Logical read (blocks): | 49,851.4 | 2,244.0 | | |
| Block changes: | 2,963.2 | 133.4 | | |
| Physical read (blocks): | 13,955.6 | 628.2 | | |
| Physical write (blocks): | 132.9 | 6.0 | | |
| Read IO requests: | 995.0 | 44.8 | | |
| Write IO requests: | 54.9 | 2.5 | | |
| Read IO (MB): | 109.0 | 4.9 | | |
| Write IO (MB): | 1.0 | 0.1 | | |
| User calls: | 1,660.8 | 74.8 | | |
| Parses (SQL): | 60.0 | 2.7 | | |
| Hard parses (SQL): | 0.2 | 0.0 | | |
| SQL Work Area (MB): | 7.4 | 0.3 | | |
| Logons: | 0.1 | 0.0 | | |
| Executes (SQL): | 1,556.0 | 70.0 | | |
| Rollbacks: | 0.1 | 0.0 | | |
| Transactions: | 22.2 | | | |
Also please see the below memory part.
Memory Statistics
| Begin | End |
|---|
| Host Mem (MB): | 258,341.7 | 258,341.7 |
| SGA use (MB): | 29,819.1 | 29,819.1 |
| PGA use (MB): | 1,785.1 | 1,784.2 |
| % Host Mem used for SGA+PGA: | 12.23 | 12.23 |
Cache Sizes
| Begin | End | | |
|---|
| Buffer Cache: | 15,360M | 15,360M | Std Block Size: | 8K |
| Shared Pool Size: | 12,822M | 12,757M | Log Buffer: | 58,336K |
Shared Pool Statistics
| Begin | End |
|---|
| Memory Usage %: | 17.13 | 25.74 |
| % SQL with executions>1: | 98.17 | 98.50 |
| % Memory for SQL w/exec>1: | 97.52 | 97.62 |
Please suggest if sga_max_size needs to be increase.
Regards
Monoj