Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What SGA for EBS R12.1 or R12.2 ?

Beauty_and_dBestAug 17 2019 — edited Feb 9 2021

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

PROD157292119PROD124-Jun-19 05:0611.1.0.7.0NO
prod.oracle.comLinux x86 64-bit88238.38
Begin Snap:7314124-Jul-19 01:00:2030523.9
End Snap:7314224-Jul-19 02:00:2230324.5
Elapsed:60.04 (mins)
DB Time:9.88 (mins)

Report Summary

Cache Sizes

Buffer Cache:11,776M11,776MStd Block Size:8K
Shared Pool Size:3,200M3,200MLog Buffer:58,728K

Load Profile

DB Time(s):0.20.10.000.01
DB CPU(s):0.20.10.000.01
Redo size:14,286.55,654.5
Logical reads:18,178.07,194.7
Block changes:100.339.7
Physical reads:2.30.9
Physical writes:2.30.9
User calls:22.69.0
Parses:6.92.7
Hard parses:0.10.0
W/A MB processed:554,938.5219,641.2
Logons:0.10.0
Executes:42.216.7
Rollbacks:1.50.6
Transactions:2.5

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:100.00Redo NoWait %:100.00
Buffer Hit %:99.99In-memory Sort %:100.00
Library Hit %:97.10Soft Parse %:99.11
Execute to Parse %:83.66Latch Hit %:99.99
Parse CPU to Parse Elapsd %:0.01% Non-Parse CPU:99.86

Shared Pool Statistics

Memory Usage %:43.4143.36
% SQL with executions>1:94.8796.81
% Memory for SQL w/exec>1:95.1897.49

Top 5 Timed Foreground Events

DB CPU58398.41
db file sequential read7,331611.08User I/O
log file sync2,853210.37Commit
local write wait594110.10User I/O
control file sequential read1,063000.07System I/O

Host CPU (CPUs: 8 Cores: 8 Sockets: 2)

0.331.192.30.10.197.6

Instance CPU

2.292.90.0

Memory Statistics

Host Mem (MB):39,299.739,299.7
SGA use (MB):15,360.015,360.0
PGA use (MB):1,906.21,906.6
% Host Mem used for SGA+PGA:43.9343.93

Main Report

Please help...

Kind regards,

jc

This post has been answered by lmu on Aug 21 2019
Jump to Answer

Comments

Post Details

Added on Aug 17 2019
8 comments
160 views