Re: severe performance issues when flashback is on
From: Sidney Chen <huanshengchen_at_gmail.com>
Date: Thu, 20 Oct 2011 13:37:31 +0800
Message-ID: <CAM_ddu-JGXxcA7Vo1cV3Y_QP=PaUA+jyssb5-+ny+oQ_iFa6qA_at_mail.gmail.com>
When flashback on, what oracle is reading during second round? the datafile or flashback logs? refer to p1/p2 of db file sequential read in the trace. i've not testing in 11gr2 myself, from MOS, the overhead is expected.
Date: Thu, 20 Oct 2011 13:37:31 +0800
Message-ID: <CAM_ddu-JGXxcA7Vo1cV3Y_QP=PaUA+jyssb5-+ny+oQ_iFa6qA_at_mail.gmail.com>
When flashback on, what oracle is reading during second round? the datafile or flashback logs? refer to p1/p2 of db file sequential read in the trace. i've not testing in 11gr2 myself, from MOS, the overhead is expected.
Flashback Database Best Practices & Performance [ID 565535.1]
--
Regards
Sidney Chen
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 20 2011 - 00:37:31 CDT