gcbufferbusy-创新互联

gc buffer busy
  This wait event, also known as global cache buffer busy prior to Oracle 10g,
  specifies the time the remote instance locally spends accessing the requested data block.
  This wait event is very similar to the buffer busy waits wait event in asingle-instance database and are often the result of: 1. Hot Blocks -
multiple sessions may be requesting a block that is either not in buffer cache or is in an incompatible mode.
Deleting some of the hot rows and re-inserting them back into the table may alleviate the problem.
 Most of the time the rows will be placed into a different block and reduce contention on the block.
 The DBA may also need to adjust the pctfree and/or pctused parameters for the table to ensure the rows are placed into a different block. 2. Inefficient Queries ˆ
as with the gc cr request wait event,
the more blocks requested from the buffer cache the more likelihood of a session having to wait for other sessions.Tuning queries to access
fewer blocks will often result in less contention for the same block.

创新互联公司长期为上千客户提供的网站建设服务，团队从业经验10年，关注不同地域、不同群体，并针对不同对象提供差异化的产品和服务；打造开放共赢平台，与合作伙伴共同营造健康的互联网生态环境。为柳州企业提供专业的成都网站设计、成都网站制作，柳州网站改版等技术服务。拥有10多年丰富建站经验和众多成功案例,为您定制开发。

当前标题：gcbufferbusy-创新互联
文章路径：https://www.cdcxhl.com/article34/cecjse.html

成都网站建设公司_创新互联，为您提供网站排名、网站设计、外贸建站、App设计、做网站、网页设计公司

广告

声明：本网站发布的内容（图片、视频和文字）以用户投稿、用户转载内容为主，如果涉及侵权请尽快告知，我们将会在第一时间删除。文章观点不代表本网站立场，如需处理请联系客服。电话：028-86922220；邮箱：631063699@qq.com。内容未经允许不得转载，或转载时需注明来源： 创新互联