Oracle Database Discussions

Hi

We are using oracle10g(10.2.0.3) on windows 2000 server

Now we are having 800 M SGA size and i want to increase 1GB

How can i increasing? and is it dynamic parameter?


SQL> select * from v$sga;

NAME VALUE
-------------------- ----------
Fixed Size 1293384
Variable Size 461374392
Database Buffers 364904448
Redo Buffers 11288576

SQL> show parameter sga

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 800M
sga_target big integer 800M
SQL>

Thanks

OH