Database Memory & 4030/4031 (MOSC)

MOSC Banner

Memory allocation

edited Dec 9, 2016 4:00AM in Database Memory & 4030/4031 (MOSC) 11 commentsAnswered

I need help to assign correct memory resources for my database

i have oracle database 12C and server specs is 16 GB Ram on linux 6.7

current configuration is :

sessions         472

processes       300

transactions    519

pga_aggregate_limit                  4G

pga_aggregate_target               2G

memory_target                          0

sga_max_size                           2256M

sga_target                                 2256M

db_cache_size                           0

i need to have session =1000

and need to know what values i should change from the above to hold a huge amount of transactions (example: 1 Million Trx per day) and do i need to change SGA or PGA or DB cache size?

also what is transaction value refer to and what value should it be?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center