memory resource...
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 anotherdb 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.
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 anotherdb 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.
RE: memory resource...
Shuan, The oracle.exe process memory usage is dependant on the size of the SGA. The difference in the memory used for each of the oracle.exe processes is due to the different SGA sizes. Regards $uhen 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 anotherdb 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.
Re: memory resource...
hi! john... while i installed the first db, it only consumes 10,000~20,000K memory. afterthe 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 - From: orantdba To: 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[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 anotherdb 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.
