更改oracle系統引數例子

mrhaozi發表於2009-12-10

ALTER SYSTEM SET pga_aggregate_target = 2000M
ALTER SYSTEM SET sga_max_size = 4500M SCOPE=SPFILE
ALTER SYSTEM SET sga_target = 4000M SCOPE=SPFILE
ALTER SYSTEM SET db_file_multiblock_read_count = 64

ALTER SYSTEM SET parallel_server = TRUE SCOPE=SPFILE


ALTER TABLESPACE TB_ODS ADD DATAFILE '/data/oracle/oradata/pmias/apods08.dbf' SIZE 16384M AUTOEXTEND OFF;

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/16396910/viewspace-1029563/,如需轉載,請註明出處,否則將追究法律責任。

相關文章