Re: memory resource...

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.
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

• Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt ·s²Ó©úÅé; font-color: black">From: <A href="mailto:orantdba_at_netscape.net" title=orantdba_at_netscape.net>orantdba To: <A href="mailto:ORACLE-L_at_fatcity.com" title=ORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L 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 theseparameters.  The most likely culprits,  db_block_buffers,  shared_pool_size,sort_area_size and log_buffer_size.  However you didn't mentioned why you wantthem to be smaller. It is possible they were set by the previous dba at these valuesto maximize performance of the system.  Setting them smaller could negatively effect performance.Why do you want to make these smaller?JOhn<A class=moz-txt-link-abbreviated href="mailto:shuan.tay_at_pci.co.id">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 Thu Jan 17 2002 - 00:11:10 CST