Since the upgrade of the production database from 8i (8.1.7.4) to 10g (10.2.0.3) x64 in March this year, it has been a nightmare. First, the number of sessions is increasing, and then the problem is solved, and memory leakage occurs again. About MB of memory is leaked every day. 8 GB of memory is leaked in one week, causing Oracle service to be restarted.
I keep surfing the internet for help every day, so I keep hoping and getting disappointed. New patches are constantly upgraded and Memory leakage occurs. It has been tortured and cannot be tolerated.
The day before yesterday, as shown in the following example, I went to the Oracle website again to see if there were any new patches and found patch7. I'm too lazy to test it. The result is not smooth and the upgrade fails. Shutdown again. Success. The next day, I turned on spotlight and found that the memory was not reduced. It was so excited. Today is the third day, and it is still not reduced. It seems that the memory leakage has been solved.
Finally solved the problem.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
