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 change for the DB

3035820Jan 10 2016 — edited Jan 11 2016

Hi,

There is one change we to need to do . Could you please confirm the following steps?

1.Take spfile backup in text format

not sure how to do this step

2.Change sga_max_size and sga_target parameters to 3 GB

alter system set sga_max_size=3G scope=spfile;

alter system set sga_target=3G;

3.Bounce the db and verify the change

shutdown immediate

startup

Oracle -- 10.2.0.3.0

OS -- AIX

Regards,

Bala

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 8 2016

Added on Jan 10 2016

#general-database-discussions

25 comments

4,020 views