Oracle 7 Memory Leak .. [message #51523] |
Tue, 28 May 2002 10:29 |
cidu
Messages: 5 Registered: May 2002
|
Junior Member |
|
|
We have an Oracle 7.3 server running on W2k; Every week I have to stop/start Oracle, otherwise, Oracle service will be crashed. I watched the memory from Task Memanger, Oracle service mem usage reached 700M. If I use "Alter system flsh shard_pool"; nothing changed in task manager.
By the way, we only have 10 con-current users normally.
Can anyone help me? Thank you very much!
|
|
|
|
Re: Oracle 7 Memory Leak .. [message #51532 is a reply to message #51523] |
Tue, 28 May 2002 20:59 |
Vikas Gupta
Messages: 115 Registered: February 2002
|
Senior Member |
|
|
Pls. check your SGA. I think it is big.
Run the following querry:
select to_number(v$parameter.value) value,
v$sgastat.bytes, v$sgastat.bytes/v$parameter.value *100
"Percent Free" from v$sgastat, v$parameter where v$sgastat.name
= 'free memory' and v$parameter.name = 'shared_pool_size';
After the database is running for some period of time..the percent free should not be more then 5% continuously..reduce the shared_pool_size parameter.
|
|
|