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!

ALTER SYSTEM SET SGA_TARGET

happy10319Jun 7 2009 — edited Jun 7 2009

Hi,
in 10g R2 should I stop/start database when I change sGA_TARGET :

ALTER SYSTEM SET SGA_TARGET=value [SCOPE={SPFILE|MEMORY|BOTH}]

Thank you.

This post has been answered by Satish Kandi on Jun 7 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 5 2009

Added on Jun 7 2009

#general-database-discussions

9 comments

54,047 views