Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

Memory leak in Oracle 8.1.7 ?

SOLVED
Go to solution
Stefan Farrelly
Honored Contributor

Memory leak in Oracle 8.1.7 ?

Hi all,

Does anyone know of a memory leak in Oracle 8.1.7 ? We have a problem on an N class whereby when all the oracle databases are shutdown each night the amount of user memory does not return to the same level as after a reboot - we are about 1GB short! It appears all shared memory and semaphores are removed aok (ipcs confirms), and all processes stopped, but were still using 1GB more than we should be. Either oracle 8.1.7 isnt freeing up all the memory it was using or we need an hp-ux patch which will free it up. Anyone know of either ?

Cheers,

Stefan
Im from Palmerston North, New Zealand, but somehow ended up in London...
6 REPLIES
Steve Steel
Honored Contributor
Solution

Re: Memory leak in Oracle 8.1.7 ?

Stefan Farrelly
Honored Contributor

Re: Memory leak in Oracle 8.1.7 ?


Thanks Steve,

very helpful. Definite memory leak in 8.1.7 - will pass to our DBA's/Oracle to get the needed Oracle patches and install.

Cheers,

Stefan
Im from Palmerston North, New Zealand, but somehow ended up in London...
Tom Geudens
Honored Contributor

Re: Memory leak in Oracle 8.1.7 ?

Hi,
Just a little warning (and this information is "as is") : Do NOT upgrade to the 8.1.7.3 release (8.1.7.2 is fine and will solve your memory problems). We've got very serious problems after this upgrade (with queries / with the system-tablespace / with analyze) and Oracle is still looking for solutions.

Regards,
Tom
A life ? Cool ! Where can I download one of those from ?
Juan Manuel López
Valued Contributor

Re: Memory leak in Oracle 8.1.7 ?

Could you please give more information about this problem?
We are just beggining to upgrade to 8.1.7.3 from 8.1.6.0. I am very interesting about more information.
Thanks in advance.
Juanma.
I would like to be lie on a beautiful beach spending my life doing nothing, so someboby has to make this job.
Stefan Farrelly
Honored Contributor

Re: Memory leak in Oracle 8.1.7 ?

Tom,

Thanks for the warning about 8.1.7.3 !

Cheers,

Stefan
Im from Palmerston North, New Zealand, but somehow ended up in London...
Tom Geudens
Honored Contributor

Re: Memory leak in Oracle 8.1.7 ?

Hi,
The information I have on the 8.1.7.3 problems (2 and 3 are "open calls" with Oracle) :
1) Certain types of complicated queries do NOT work anymore. You can find - so I'm told by our DBA's - information on this at Metalink. This seems to be "a works as designed" problem.
2) Last week we had some processes blocking an analyze. Through searching we located a culprit DBprocess, which on first view seemed blocked itself on an I/O (on the system tablespace), but on second view was CPU looping. We had to rewrite this BO (Bussiness Objects) application.
3) This morning several sqlload's threw a lot of ORA-600 problems (causing the trace directory to "overflow"). This problem is still being looked at, but seems to focus on the system tablespace once more.

Ok, this is the information. It is "as is". These problems may just be "local" problems (well, 1. and 2. are verified to be "global" problems :-). Everything may work fine in your environment. Let's just say that we decided not to continue the upgrades to 8.1.7.3 for the time being.

Regards,
Tom
A life ? Cool ! Where can I download one of those from ?