High Avg global cache cr block flush time but low gcs log flush sync wait time
From: 刘Qinliu <ivyliu_99_at_hotmail.com>
Date: Sat, 24 Oct 2015 09:31:52 +0800
Message-ID: <BLU185-W364CD730D4FCE2C6122D986250_at_phx.gbl>
Hi,listOracle:11.2.0.3.0 on AIX-Based Systems (64-bit)the Avg global cache cr/current block flush time (ms) is highBut the gcs log flush sync wait is much lower.For my understanding, they are descripting the same thing. How could be the average time so different.Avg global cache cr block flush time (ms):905.3Avg global cache current block pin time (ms):0.0Avg global cache current block send time (ms):0.0Global cache log flushes for current blocks served %:0.8Avg global cache current block flush time (ms):1,273EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg timegcs log flush sync705,626112,28430.4546.79log file parallel write235,999054720.1511.21
Date: Sat, 24 Oct 2015 09:31:52 +0800
Message-ID: <BLU185-W364CD730D4FCE2C6122D986250_at_phx.gbl>
Hi,listOracle:11.2.0.3.0 on AIX-Based Systems (64-bit)the Avg global cache cr/current block flush time (ms) is highBut the gcs log flush sync wait is much lower.For my understanding, they are descripting the same thing. How could be the average time so different.Avg global cache cr block flush time (ms):905.3Avg global cache current block pin time (ms):0.0Avg global cache current block send time (ms):0.0Global cache log flushes for current blocks served %:0.8Avg global cache current block flush time (ms):1,273EventWaits%Time -outsTotal Wait Time (s)Avg wait (ms)Waits /txn% bg timegcs log flush sync705,626112,28430.4546.79log file parallel write235,999054720.1511.21
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Oct 24 2015 - 03:31:52 CEST