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!

View parameters that will change after Oracle restart

1049507Apr 8 2014 — edited Apr 8 2014

Hi All,

Oracle 11g

Linux

My current SGA is 700M.

If I give:

SQL> alter system set sga_max_size=2G scope=spfile;

System altered.

SQL> alter system set sga_target=2G scope=spfile;

System altered.

After this, I am not going to restart the database. But, now, I type "show SGA" it is showing 700M.

My question is: How can I see the parameter values that will change after instance restart? Thanks,

This post has been answered by unknown-698157 on Apr 8 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 6 2014

Added on Apr 8 2014

#general-database-discussions

2 comments

2,720 views