The Oracle tutorial you are looking at is: Oracle capture problem SQL resolves CPU transition consumption. This paper attempts to provide a diagnostic method for common CPU consumption problems through a case of adjustment in the actual business system. In most cases, the performance problems of the system are caused by bad SQL code, so how to find and solve these SQL problems is particularly important as a DBA.
This case platform is UNIX, so it is unavoidable to apply some common tools under UNIX. such as Vmstat,top.
This article is suitable for readers: senior.
System environment:
Os:solaris8
oracle:8.1.7.4
Problem Description:
The developer reports that the system is running slowly and has affected the normal use of the business system. Request assistance for diagnosis.
1. Login to database Host
Using the Vmstat check, you discover that CPU resources have been depleted and that a large number of tasks are in the run queue:
2. Using the top command
Observe process CPU consumption and discover processes without significantly excessive CPU usage
3. Check the number of processes
Discovery System There is a large number of Oracle processes, around 300, a large number of processes consume almost all CPU resources, and normally the number of Oracle connections should be about 100.
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.
