good day

I have an Oracle-XE 11g database on my VPS server (Ubuntu 14).

Faced with the fact that the database is quieter than we would like. I want to increase the amount of memory allocated for the database, but it does not work. In apex memory is absent (I login under admin), if the interface were available, it would be more or less clearly described here: https://docs.oracle.com/cd/B25329_01/doc/admin.102/b25107/memory.htm .

In general, I will be very happy if you help increase the memory allocated for Oracle. Perhaps there is a 1G limit for XE.

root@s05657de2:~#free -h total used free shared buffers cached Mem: 6.0G 732M 5.3G 327M 0B 596M -/+ buffers/cache: 136M 5.9G Swap: 2.0G 0B 2.0G root@s05657de2:~# df -h Filesystem Size Used Avail Use% Mounted on /dev/ploop11458p1 40G 3.8G 35G 11% / none 3.0G 4.0K 3.0G 1% /dev none 4.0K 0 4.0K 0% /sys/fs/cgroup none 615M 44K 615M 1% /run none 5.0M 0 5.0M 0% /run/lock none 3.0G 0 3.0G 0% /run/shm none 100M 0 100M 0% /run/user shmfs 4.0G 259M 3.8G 7% /dev/shm
  • Memory settings - global settings. change in configs and require a restart of the north. do not forget to backup (init / spfile), otherwise you may not start after the change. community.oracle.com/thread/945562?tstart=0 - Mike
  • Are you talking about /u01/app/oracle/product/11.2.0/xe/dbs/spfileXE.ora? I understand you need to change these lines: XE .__ java_pool_size = 4194304 XE .__ large_pool_size = 4194304 XE .__ oracle_base = '/ u01 / app / oracle' XE .__ shared_pool_size = 155189248 XE .__ streams_pool_size = 0 - Vyacheslav Groshenkov

0