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!

SGA_TARGET not increasing

dbdanAug 11 2009 — edited Aug 11 2009

Hi All,

I have following parameters related to SGA:
SGA_MAX_SIZE = 2512 MB
SGA_TARGET = 704 MB

Since my system is taking lot of time for SQL execution. I want to make SGA_TARGET = SGA_MAX_SIZE. But when I issue following command:

alter system set sga_target = 2512 scope = both;

I am getting following error:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00827: could not shrink sga_target to specified value

I am not shrinking my SGA_TARGET, then what this error means?

I am using Oracle 10g R2 on windows.

Regards.

Edited by: dbdan on Aug 11, 2009 5:39 AM
DB version added

This post has been answered by Uwehesse-Oracle on Aug 11 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 8 2009

Added on Aug 11 2009

#general-database-discussions

8 comments

2,263 views