Shulou(Shulou.com)06/01 Report--

This article will explain in detail how to solve the system performance failure caused by oracle audit. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

There have been several alarms on the database host that the CPU resource occupancy rate is too high, resulting in poor performance of the host. After some investigation, the cause of the problem is finally found out and the fault is solved. The specific process is as follows:

Environment: host SUSE LINUX 10 (64 bit) ORACLE11G (64 bit)

First, alarm message (fault presentation)

The current value of suselinux server CPU utilization is 90.93, the threshold range is [90-100], and the occurrence time is 11:17:01

The current value of suselinux server CPU utilization is 92.20, the threshold range is [90-100], and the occurrence time is 14:46:02

The current value of suselinux server CPU utilization is 92.54, the threshold range is 90-100, and the occurrence time is 15:14:01.

2. Analysis process (fault investigation)

1. Use the TOP command to view system resources

Shift plus P: sorted by CPU resource utilization descending order shift plus M: sorted by memory occupancy resource ratio descending order

We found that the occupancy rate of ORACLE processes was high, and CPU exceeded the limit several times to more than 90%, which seriously affected the performance of the system.

2. Use the SAR command to check IO and transmission:

Note: to use the sar command under suse linux, you need to install the sysstat package.

Through the AWR report, it is found that the audit table is updated frequently, and there are more report updates on the same day.

4. Connect to the database and verify the audit and index.

6. Follow-up optimization:

Verify SQL statements to avoid excessive consumption of CPU resources caused by buffer cache conflicts caused by high concurrent execution of inefficient statements.

This is the end of the article on "how to solve the system performance failure caused by oracle audit". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

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.