How to cut down on the amount of memory 11g uses.

From: <awatkins1966_at_googlemail.com>
Date: Mon, 4 Aug 2008 07:05:41 -0700 (PDT)
Message-ID: <92bb81d3-1aa4-475f-83ef-4a2d583c43d6@k30g2000hse.googlegroups.com>

Hi folks!

Just install 11g and created a standard database and I was shocked with the amount of memory it uses and the number of processes it runs. Any pointers on how to reduce the foot print.

State of play after a default install:

40 Processes with a total of 62GB of virtual memory

# ps -eo user,vsz,comm

  oracle 1.7GB oracleteach
  oracle 1.6GB ora_lgwr_teach
  oracle 1.6GB ora_mmon_teach
  oracle 1.6GB ora_w000_teach
  oracle 1.6GB ora_smon_teach
  oracle 1.6GB ora_dbw0_teach
  oracle 1.6GB oracleteach
  oracle 1.6GB ora_cjq0_teach
  oracle 1.6GB oracleteach
  oracle 1.6GB oracleteach
  oracle 1.6GB oracleteach
  oracle 1.6GB oracleteach
  oracle 1.6GB oracleteach
  oracle 1.6GB oracleteach
  oracle 1.6GB ora_ckpt_teach
  oracle 1.6GB oracleteach
  oracle 1.6GB oracleteach
  oracle 1.6GB oracleteach
  oracle 1.6GB oracleteach
  oracle 1.6GB ora_pmon_teach
  oracle 1.6GB oracleteach
  oracle 1.6GB ora_s000_teach
  oracle 1.6GB ora_q001_teach
  oracle 1.6GB ora_d000_teach
  oracle 1.6GB ora_fbda_teach
  oracle 1.6GB ora_dia0_teach
  oracle 1.6GB ora_mmnl_teach
  oracle 1.6GB ora_q000_teach
  oracle 1.6GB ora_dbrm_teach
  oracle 1.6GB ora_reco_teach
  oracle 1.6GB ora_qmnc_teach
  oracle 1.6GB ora_vktm_teach
  oracle 1.6GB ora_smco_teach
  oracle 1.6GB ora_psp0_teach
  oracle 1.6GB ora_mman_teach
  oracle 1.6GB ora_diag_teach

  oracle 317264 /ora01/app/oracle/product/11.1.0/db_1/jdk/bin/sparcv9/ java

  oracle 71000 /ora01/app/oracle/product/11.1.0/db_1/bin/emagent
  oracle 48224 /ora01/app/oracle/product/11.1.0/db_1/bin/tnslsnr
  oracle 18784 /ora01/app/oracle/product/11.1.0/db_1/perl/bin/perl

  oracle 3680 /ora01/app/oracle/product/11.1.0/db_1/ccr/bin/nmz   oracle 2064 -csh

Thanks

Andrew Received on Mon Aug 04 2008 - 09:05:41 CDT