gc cr request '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.
[@more@]
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.
[@more@]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9533994/viewspace-1016077/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- gc cr request等待事件GC事件
- 【等待事件】global cache cr request/gc current request事件GC
- 儲存過程遇到gc cr request等待儲存過程GC
- innodb_flush_log_at_trx_commit和sync_binlog innodb_flush_methodMIT
- mysql sync_binlog和 innodb_flush_log_at_trx_commitMySqlMIT
- sync_binlog和innodb_flush_log_at_trx_commit解析MIT
- 如何診斷RAC系統中的'gc cr multi block request'?GCBloC
- 【MySQL】sync_binlog innodb_flush_log_at_trx_commit 淺析MySqlMIT
- oracle 10.2.0.1 rac發現sql查詢hang之gc cr requestOracleSQLGC
- 【MySQL】五、sync_binlog innodb_flush_log_at_trx_commit 淺析MySqlMIT
- gc current block pin time gc current block flush time 疑惑GCBloC
- gc current/cr block busy等待事件GCBloC事件
- Asp.Net Sync & ASync Processing requestASP.NET
- 解決gc current request等待事件GC事件
- innodb_flush_method和innodb_flush_log_at_trx_commitMIT
- gc current request等待時間處理GC
- innodb_flush_log_at_trx_commitMIT
- flush logs時做的操作
- log file sync等待事件事件
- 【等待事件】log file sync事件
- log file sync" 等待事件事件
- log file sync 和 log file parallel writeParallel
- _use_adaptive_log_file_sync設定 降低log_file_sync等待APT
- dialog on input OR on request
- "log file sync"等待事件-2事件
- "log file sync"等待事件-1事件
- 等待事件 log file sync 小解事件
- Go - 使用 sync.Pool 來減少 GC 壓力GoGC
- gc current request 引起長期鎖表的故障GC
- 一個疑惑 ,gc cr grant 2-way ,簡單記錄GC
- _use_adaptive_log_file_syncAPT
- log file sync等待事件總結事件
- log file sync等待事件處理思路事件
- 關於gcs_resources:GC
- mysql效能引數innodb_flush_log_at_trx_commitMySqlMIT
- 【WAIT】 log file sync等待事件說明AI事件
- 【RAC】RAC 效能分析 - 'log file sync' 等待事件事件
- 關於log file sync等待事件的描述事件