In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-03 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
Recently, a very strange thing encountered in oracle rac maintenance is that the business is occasionally extremely slow, but the server load and database load are very low, there are no obvious errors in the database and host logs, and there is no session congestion within the database. This article is hereby recorded for later reference!
Background: since December, the application begins to give feedback, and it will be very slow to issue documents every time a new product is released. Later, in order to temporarily solve the problem, the business is directed to a single node, and it is found that the business distribution speed returns to normal. Later, after a week or so, the issuing speed of the documents was very slow again. However, the server load and database load are very low, there are no obvious errors in the database and host logs, and there is no session congestion within the database. In order to resume business as soon as possible, the database service was restarted
Business returns to normal for the time being. However, three or four days later, that is, today, there was another slow issuance of documents.
Problem analysis:
1. Based on the above background, there is no high load on the database and host, especially when there is no session congestion inside the database. What I can think of is that the SQL execution plan may have changed.
2. View the SQL statement executed by the service bearer node
3. View the execution plan of sql-5216pwt38ckhp
Excellent implementation plan, a document issued at 3-8 o'clock can be executed nearly 30 times
-- after the change, the inefficient implementation plan will be issued at 3-10:00 at a time, and only one time will be completed.
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.