hi! john...
while i installed the first db, it only consumes
10,000~20,000K memory.
after the error occurred(ORA-12638, which solved
now), it becomes memory sucker.
that's why i'm curious about it.
and..i'm learning oracle, so my pc will b quite slow
if oracle consumes too many memory.
and i didnt change any setting for init
file.
so i feel strange why it changed itself.
thanks for ur answer.
good day and hav a nice day.
----- Original Message -----
Sent: Thursday, January 17, 2002 11:10
AM
Subject: Re: memory resource...
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
[EMAIL PROTECTED] 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.
|