SGA_TARGET

From: <rubanp_at_gmail.com>
Date: 24 Sep 2006 23:02:32 -0700
Message-ID: <1159164152.442566.220300@m7g2000cwm.googlegroups.com>

I have the following error when i try to increase my sga_target in 10g.

SQL> show parameter sga

NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------
lock_sga                             boolean     FALSE
pre_page_sga                         boolean     FALSE
sga_max_size                         big integer 160M
sga_target                           big integer 160M

SQL> show parameter timed_statis

NAME                                 TYPE        VALUE
------------------------------------ ----------- --------------
timed_statistics                     boolean     TRUE

SQL> SQL> alter system set sga_target=170M;
alter system set sga_target=170M
*

ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00823: Specified value of sga_target greater than sga_max_size

SQL> alter system set sga_target=180M;
alter system set sga_target=180M
*

ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-00823: Specified value of sga_target greater than sga_max_size

Regards
Ruban.P
India Received on Mon Sep 25 2006 - 01:02:32 CDT