Reducing CPU problem caused due to high buffer gets (after large delete)
来源:互联网 发布:淘宝商家怎么入驻 编辑:程序博客网 时间:2024/06/07 18:42
Reducing CPU problem caused due to high buffer gets.
Couple of month’s back I was working on tuning one of the telecom databases which was occupying almost 90% of the CPU in peak times.
While interpreting the statspack report I found that one of their queries is consuming more CPU and it has more buffer gets, their count running into some crores.
I was looking at that particular query and surprised to find that it has only 20 records in that table and performing a full table scan. Based on this I ran the following query
select blocks,num_rows from dba_tables where owner='XYZ';
to get the no of blocks the table has occupied and found that it has occupied 1500 blocks for 20 rows. Each time the query runs, it is scanning 1200 blocks for 20 records which is the cause for the high CPU consumption.
The CPU came back to 20% after recreating the table where it occupied 2 blocks for 20 records.
The reason for this is that, the table used to have millions of records earlier and they have performed a delete operation, which is the cause for blocks not being released after the delete.
Couple of month’s back I was working on tuning one of the telecom databases which was occupying almost 90% of the CPU in peak times.
While interpreting the statspack report I found that one of their queries is consuming more CPU and it has more buffer gets, their count running into some crores.
I was looking at that particular query and surprised to find that it has only 20 records in that table and performing a full table scan. Based on this I ran the following query
select blocks,num_rows from dba_tables where owner='XYZ';
to get the no of blocks the table has occupied and found that it has occupied 1500 blocks for 20 rows. Each time the query runs, it is scanning 1200 blocks for 20 records which is the cause for the high CPU consumption.
The CPU came back to 20% after recreating the table where it occupied 2 blocks for 20 records.
The reason for this is that, the table used to have millions of records earlier and they have performed a delete operation, which is the cause for blocks not being released after the delete.
- Reducing CPU problem caused due to high buffer gets (after large delete)
- Node Eviction due to OLOGGERD High CPU
- High "gc buffer busy acquire" wait after Upgrade to 11.2 (文档 ID 2047582.1)
- High CPU caused by TortoiseSVN process TSVNCache.exe
- The project was not built due to "Could not delete ''.". Fix the problem, then try refreshing this p
- The project was not built due to "Could not delete
- High Waits on 'Db File Sequential Read' Due to Table Lookup Following Index Access
- CRT detected that the application wrote to memory after after the end of heap buffer
- Caused by: com.mysql.jdbc.exceptions.MySQLTimeoutException: Statement cancelled due to timeout or cl
- How to do High Quality Research and Run a large Research Group
- Problem B Back to High School Physics Form UVAoJ 10071
- Handling large/high resolution images
- mysql No operations allowed after connection closed.Connection was implicitly closed due to underly
- Reducing CPU usage in Adobe AIR
- intel-amt-vulnerability-- memcmp and strncmp function calls can be skipped due to incorrect buffer l
- Howto Fix ureadahead problem after upgrading to Ubuntu 10.04
- Caused by: android.database.StaleDataException: Attempted to access a cursor after it has been close
- Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is rec
- 周其仁:经济增长与企业成长
- 二十一世纪科学和数学的趋势
- using INSTR function for obtaining data from a table, based on a selection from the master table (FK relation)
- 人工神经网络
- 移动硬盘分区误删后修复手记
- Reducing CPU problem caused due to high buffer gets (after large delete)
- [转]以色列教育孩子的方式
- 限制文本输入框textarea最大输入字符的js
- 数学的内容、方法和意义(转载)
- pb 关于VARCHAR(2000)的处理
- linux 笔记
- 哈利·M·卡特:鸡蛋、篮子和投资组合
- 常用单位换算
- 成功创业家的心理特征