Showing posts with label Job. Show all posts
Showing posts with label Job. Show all posts

2012/02/05

Database parameter setting (Reference)



alter system set processes=300 scope=spfile;
alter system set session_cached_cursors=200 scope=spfile;
alter system set sga_target=2G scope=spfile;
alter system set shared_pool_size=600M scope=spfile;
alter system set pga_aggregate_target=1G scope=spfile;
alter system set job_queue_processes=20 scope=spfile;