Showing posts with label Oracle XE. Show all posts
Showing posts with label Oracle XE. Show all posts

Tuesday, May 19, 2009

Change sessions, transaction and processes parameters in Oracle 10g

alter system set PROCESSES=100 scope=SPFILE;
alter system set TRANSACTIONS=126 scope=SPFILE;
alter system set SESSIONS=115 scope=SPFILE;

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;