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!

Memory Parameters

666246Nov 9 2009 — edited Apr 5 2011

Hi,

I'm using 11g (11.1.0.6.0). I had put related question previously but still little confused. To support my question, I've showed some parameters below:

SQL> show parameter sga

- - -
sga_max_size 308M
sga_target 0

SQL> show parameter target

- - - -
memory_max_target 408M
memory_target 408M
pga_aggregate_target 0
sga_target 0

Please tell me how much RAM is allocated for my Oracle database based on these above parameters???

Secondly which parameter I can decrease from above to decrease the RAM for db. My main concern is to decrease the RAM used for my database.

Please help.

Thanks alot.

Best Regards,
KAM

Locked Post

New comments cannot be posted to this locked post.

Locked on May 3 2011

Added on Nov 9 2009

#11g, #general-database-discussions

16 comments

2,951 views