Hi,
I have installed Oracle XE 10g on Linux (32-bit) with modest resources (i.e. 512MB RAM).
Everything seems to run well.i
I intention is to use this installation to run very basic integration tests only.
So, it won't be used in multi-user or production environment.
I imagine, it should be possible to tweak the XE configuration and decrease its footprint even more,
to instruct automatic resources management to not to be ready for 20 simultaneous connections
(as I understand that's the default), but 5, and such.
Could anyone advise on the following settings?
1) Is it possible to decrease memory allocation? I have learned a bit about SGA and PGA settings, but I;m not sure what's a reasonable limit here.
2) Is it possible to disable number of connections , as explained above.
3) Is it possible to completely disable unused components, like some application servers, Java applications, and such. I have already tried to set the HTTP port to 0,
but there may be is more aggressive policy possible.
4) Any chance to cut down the nubmer of spawned processes?
Currenly, I'm getting this:
# ps aux | grep oracle
oracle 14065 0.0 0.5 21652 5864 ? Ss 22:35 0:00 /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr LISTENER -inherit
oracle 14161 0.0 0.9 370360 10204 ? Ss 22:36 0:00 xe_pmon_XE
oracle 14163 0.0 0.8 369744 8828 ? Ss 22:36 0:00 xe_psp0_XE
oracle 14165 0.0 1.7 369744 18132 ? Ss 22:36 0:00 xe_mman_XE
oracle 14167 0.0 1.1 371812 12048 ? Ss 22:36 0:00 xe_dbw0_XE
oracle 14169 0.0 2.6 385296 28232 ? Ss 22:36 0:00 xe_lgwr_XE
oracle 14171 0.0 1.3 369752 14076 ? Ss 22:36 0:00 xe_ckpt_XE
oracle 14173 0.0 3.9 370276 41392 ? Ss 22:36 0:00 xe_smon_XE
oracle 14175 0.0 1.3 369744 14064 ? Ss 22:36 0:00 xe_reco_XE
oracle 14177 0.0 1.9 371340 20476 ? Ss 22:36 0:00 xe_cjq0_XE
oracle 14179 0.0 4.0 372488 42588 ? Ss 22:36 0:00 xe_mmon_XE
oracle 14181 0.0 1.0 369744 10892 ? Ss 22:36 0:00 xe_mmnl_XE
oracle 14183 0.0 0.8 370408 8960 ? Ss 22:36 0:00 xe_d000_XE
oracle 14185 0.0 0.8 370356 8628 ? Ss 22:36 0:00 xe_s000_XE
oracle 14187 0.0 0.8 370356 8632 ? Ss 22:36 0:00 xe_s001_XE
oracle 14189 0.0 0.8 370356 8624 ? Ss 22:36 0:00 xe_s002_XE
oracle 14191 0.0 0.8 370356 8632 ? Ss 22:36 0:00 xe_s003_XE
oracle 14196 0.0 0.9 369744 9968 ? Ss 22:36 0:00 xe_qmnc_XE
oracle 14223 0.0 1.0 369740 10992 ? Ss 22:36 0:00 xe_q000_XE
oracle 14225 0.0 0.8 369740 9288 ? Ss 22:36 0:00 xe_q001_XE
Basically, what can I do to make the Oracle XE 10g configuration on Linux as lightweight as possible?
I'd apreciate any hel,
Mateusz Loskot
Edited by: mloskot on Feb 21, 2013 6:25 PM
Edited by: mloskot on Feb 25, 2013 12:29 PM