Tuesday, May 19, 2009

Tuning Oracle XE

CONNECT SYS/CONTRASEÑA@XE AS SYSDBA;
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=10;
ALTER SYSTEM SET AQ_TM_PROCESSES=1;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8;
SHUTDOWN;
STARTUP RESTRICT;
SHUTDOWN;
STARTUP;


alter system set aq_tm_processes = 1 scope=both;

alter system set db_cache_size = 150994944 scope=both;
alter system set db_file_multiblock_read_count = 32 scope=both;
alter system set db_recovery_file_dest_size = 2147483648 scope=both;
alter system set java_pool_size = 125829120 scope=both;
alter system set large_pool_size = 4194304 scope=both;
alter system set max_commit_propagation_delay = 1 scope=both;
alter system set open_cursors = 400 scope=both;
alter system set pga_aggregate_target = 203423744 scope=both;
alter system set processes = 300 scope=spfile;
alter system set session_max_open_files = 50 scope=spfile;
alter system set sessions = 400 scope=spfile;
alter system set sga_max_size = 629145600 scope=spfile;
shutdown;

alter system set sga_target = 629145600 scope=spfile;
alter system set shared_pool_size = 184549376 scope=both;
alter system set star_transformation_enabled = TRUE scope=both;
alter system set max_commit_propagation_delay=700 scope=both;
alter system set max_dispatchers=5 scope=both;
alter system set max_shared_servers=20 scope=both;
alter system set max_enabled_roles=150 scope=both;
alter system set shared_server_sessions=165 scope=both;
alter system set sort_area_size=524288 scope=both;
SHUTDOWN;
STARTUP RESTRICT;
SHUTDOWN;
STARTUP;

0 comments: