Re: Memory leak

Adolfo wrote:

>Thank you Dan
>
>But the question is that we have another machine with 8.1.7.3 and this run
>OK?. Any other ideas ?
>
>Adolfo
>
>Dan Yusuph ha escrito:
>
>
>
>>Adolfo <air_at_tid.es>
>>wrote in message news:3F701E51.26B98133_at_tid.es...
>>
>>
>>
>>>We are using oracle server 8.1.7.3 and solaris 2.6. We have put the
>>>latest patchset for solaris 2.6 but when we run a heavy query the system
>>>memory go down quickly. Our SGA is 300Mb. When we shutdown our instance
>>>the system not recovery the memory and we have to reset the machine.
>>>
>>>Any ideas?
>>>
>>>
>>apply 8.1.7.4.1 patchset
>>
>>Dan
>>
>>

SELECT name, value
FROM v_$parameter;

and compare the results.

Also compare /etc/system on the two machines.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)