Oracle Database Discussions

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!

11g/12c Memory Allocation

Beauty_and_dBestOct 26 2019 — edited Nov 13 2019

11g/12c

OL6

Hi ALL,

I have set our database total memory to approximately 34Gb,

Broken down as follows:

SGA_TARGET=14G

PGA_AGGREGATE_TARGET=20G

PROCESSES=2500

SESSIONS=5000

SHARED_POOL_SIZE=3000M

SHARED_POOL_RESERVED_SIZE=300M

Is there a sql query that can check how much of the 34G is being used?

Or how do I know if it is enough for our current production system?

Please help...

Kind regards,

This post has been answered by Jonathan Lewis on Oct 26 2019

Jump to Answer

Added on Oct 26 2019

#general-database-discussions

16 comments

628 views