Re: memory resource...

From: orantdba <orantdba_at_netscape.net>
Date: Wed, 16 Jan 2002 19:39:28 -0800
Message-ID: <F001.003F231C.20020116191020@fatcity.com>

Hi Shuan,

This has nothing to do with how your service is started and everything to do with the
value of the initiazation paramaters that are used to start the database. The simple
answer is that you can get oracle to use less memory by reducing the value of these
parameters. The most likely culprits, db_block_buffers, shared_pool_size, sort_area_size and log_buffer_size. However you didn't mentioned why you want
them to be smaller. It is possible they were set by the previous dba at these values
to maximize performance of the system. Setting them smaller could negatively

effect performance.

Why do you want to make these smaller?

JOhn

shuan.tay_at_pci.co.id wrote:

  hi, DBAs...

  i'm using Win2000 Advance Server,
  with Oracle Enterprise Edition 8.1.6.
  by using task manager,
  i found tat the ORACLE.EXE is using about 58,556K memory for one db,
  which is start manually.
  and ORACLE.EXE for another db is only about 10,000K,
  which is start automatically when server start.

  is it that problem of manually start?
  how can i reduce the memory resource used by oracle?

  thanks...
  and hav a nice day.             Received on Wed Jan 16 2002 - 21:39:28 CST