You can certainly limit the amount of memory used by the database within the oracle tunable parameters and in the /etc/security/limits.conf file, but if it isn't causing any other issues for you, you will be introducing an artificial bottleneck.
Justin On Wed, 25 Jun 2008 10:59 am, Yashpal Nagar wrote: > On Wed, Jun 25, 2008 at 3:22 PM, <[EMAIL PROTECTED]> wrote: >> The memory utilization is dependent on the size of the database. Are >> you >> sure that the memory is not sitting in buffers/cache? Can you paste >> the >> output of free -m. Oracle and Sybase will consume as much memory as >> they >> are configured in the shared pool (we have some databases that use as >> little as 4gb, and the db that backs our order taking system uses up >> to >> 96GB). This will be reported as in use by the system, but will likely >> show up as buffered/cached in free, which means that memory is >> reserved >> but can be used by other processes if needed. > > ServerXX:~ # free -m > total used free shared buffers > cached > Mem: 12008 11978 30 0 216 > 11175 > -/+ buffers/cache: 587 11421 > Swap: 10236 4567 5668 > > It appears then Linux uses lot of memory as "cached" such as 1175 MB > in this case, which is nothing but free Memory reserved for other > process utilization. Is there any limits for cached/buffer part? > > Regards > Yash _______________________________________________ ilugd mailinglist -- [email protected] http://frodo.hserus.net/mailman/listinfo/ilugd Archives at: http://news.gmane.org/gmane.user-groups.linux.delhi http://www.mail-archive.com/[email protected]/
