gcs log flush sync

最新推荐文章于 2015-10-20 14:33:27 发布

aicon

最新推荐文章于 2015-10-20 14:33:27 发布

阅读量1.3k

点赞数

分类专栏： Oracle Oracle EBS 文章标签： server io

Oracle 同时被 2 个专栏收录

523 篇文章

订阅专栏

Oracle EBS

416 篇文章

订阅专栏

本文介绍了在特定数据库环境中出现的gcslogflushsync等待事件的原因及解决方案。主要原因是redo log IO性能不足导致。文章提出了两种解决方法：一是提高redo log的I/O性能；二是设置参数_cr_server_log_flush为false。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

gcs log flush sync

This is how it happens -

1)You fired an update statement on Instance-2.
2)However, the request for desired blocks was gone to Instance-1. So Instance-2 was
waiting on ''gc cr request'.
3)Instance-1 had the requested blocks but before it ships the blocks to Instance-2, it need to flush the changes from current blo
ck
to redo logs on disks. Until this is done Instance-2 waits on event - 'gcs log flush sync'.

The cause of this wait event 'gcs log flush sync' is mainly - Redo log IO performance.

To avoid this problem you need to =
1)Improve the Redo log I/o performance.
2) Set undersore parameter "_cr_server_log_flush" =false

from:http://space.itpub.net/16158219/viewspace-604587