Re: Update Statements and Exadata
From: Saibabu Devabhaktuni <saibabu_d_at_yahoo.com>
Date: Thu, 13 Dec 2012 00:31:19 -0800 (PST)
Message-ID: <1355387479.61621.YahooMailNeo_at_web161306.mail.bf1.yahoo.com>
I tested reproducing block cleanout process for queries using smart scan and confirm that full cleanout's are happening at the storage cell level and there is absolutely no redo generated for it, which means physical standby will not have any clue about these cleanout's and hence any read traffic going to active dataguard will have to keep performing in memory block cleanout's (but these buffers can't be written to disk) until same set of blocks cleaned out again with redo generation for it on primary. Thanks,
Sai
http://sai-oracle.blogspot.com
Date: Thu, 13 Dec 2012 00:31:19 -0800 (PST)
Message-ID: <1355387479.61621.YahooMailNeo_at_web161306.mail.bf1.yahoo.com>
I tested reproducing block cleanout process for queries using smart scan and confirm that full cleanout's are happening at the storage cell level and there is absolutely no redo generated for it, which means physical standby will not have any clue about these cleanout's and hence any read traffic going to active dataguard will have to keep performing in memory block cleanout's (but these buffers can't be written to disk) until same set of blocks cleaned out again with redo generation for it on primary. Thanks,
Sai
http://sai-oracle.blogspot.com
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 13 2012 - 09:31:19 CET