change oracle database initial parameter ---------------------------------------- make a backup of spfiledb.ora file at first! [oradb@instant dbs]$ pwd /oracle/10g/db/dbs [oradb@instant dbs]$ ls -al spfiledb.ora -rw-rw---- 1 oradb oinstall 2560 Jul 28 15:39 spfiledb.ora Here are the paramenters set up on instant: Current Instant SPFILE db_cache_size 301989888 301989888 pga_aggregate_target 150994944 150994944 shared_pool_size 209715200 209715200 SQL> ALTER SYSTEM SET sga_max_size = 1256M scope = spfile; SQL> ALTER SYSTEM SET db_cache_size = 576M scope=spfile; SQL> ALTER SYSTEM SET pga_aggregate_target = 288M scope=spfile; SQL> ALTER SYSTEM SET shared_pool_size = 416M scope=spfile; System altered. SQL> show parameter sga_max_size NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ sga_max_size big integer 1264M SQL> show parameter db_cache_size NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_cache_size big integer 576M SQL> show parameter pga_aggregate_target NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ pga_aggregate_target big integer 288M SQL> show parameter shared_pool_size NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ shared_pool_size big integer 416M |