Query on Real application testing
From: Lok P <loknath.73_at_gmail.com>
Date: Sun, 24 Oct 2021 16:02:13 +0530
Message-ID: <CAKna9VZQjZGx+_DDE=eOCHUVb6F=xukOkyNeH+xOgj81GROw9w_at_mail.gmail.com>
Hi, We are planning to use the real application testing feature of Oracle for capturing and replaying production workloads to see the actual impact of one of our coming versions and hardware upgrades. We have one question- before each workload replay the RAT database has to be flashed back to the point in time where we have captured the workload from. So will that flashback, remove everything from the RAT DB buffer cache and also everything will be wiped out from the storage server flash cache? And in that case the replay may not mimic the exact impact as the cache warmup will be adding additional overhead to the resource and time and thus it may not be a good comparison of before and after upgrade behaviour of RAT database. Can you please confirm if this is the correct understanding and how we should replay then to avoid this cache warmup thing? And if any other RAT system related resources can also deviate the figures?
Date: Sun, 24 Oct 2021 16:02:13 +0530
Message-ID: <CAKna9VZQjZGx+_DDE=eOCHUVb6F=xukOkyNeH+xOgj81GROw9w_at_mail.gmail.com>
Hi, We are planning to use the real application testing feature of Oracle for capturing and replaying production workloads to see the actual impact of one of our coming versions and hardware upgrades. We have one question- before each workload replay the RAT database has to be flashed back to the point in time where we have captured the workload from. So will that flashback, remove everything from the RAT DB buffer cache and also everything will be wiped out from the storage server flash cache? And in that case the replay may not mimic the exact impact as the cache warmup will be adding additional overhead to the resource and time and thus it may not be a good comparison of before and after upgrade behaviour of RAT database. Can you please confirm if this is the correct understanding and how we should replay then to avoid this cache warmup thing? And if any other RAT system related resources can also deviate the figures?
Regards
Lok
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Oct 24 2021 - 12:32:13 CEST