Database Administration (MOSC)

MOSC Banner

Can I change SGA_TARGET parameter in online? (Oracle 10g)

edited Jun 24, 2015 12:54AM in Database Administration (MOSC) 6 commentsAnswered ✓

Hello

i do not want restart instance.

I wonder SGA_TARGET change in online.

Firstly,

SQL> show parameter sga

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

lock_sga                             boolean     FALSE

pre_page_sga                         boolean     FALSE

sga_max_size                         big integer 16G

sga_target                           big integer    12G

I setted SGA_MAX_SIZE=16g , SGA_TARGET =12g

My database is online now.

And then,

I changed SGA_TARGET    as lower value than SGA_MAX_SIZE .

SQL> alter system set sga_target=15g;

System altered.

I change SGA_TARGET in online.

I did not get error.

so..

Is this effected?

i can not want restart instance.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center