Re: severe performance issues when flashback is on

From: LS Cheng <exriscer_at_gmail.com>
Date: Thu, 20 Oct 2011 16:45:31 +0200
Message-ID: <CAJ2-Qb_u_dN+4Q_SAHVKJj0Uj+wRC22m0Mi0CPfBYCFcb9V4gg_at_mail.gmail.com>

Hello
I read that note years ago but it states maximum 30% overhead but as we can see from the insert select stats it is not 30% but 300% :-)

Let me do way Jonathan suggested...

But the physical reads are from the table being inserted, I am pretty sure i CKECHED THAT BUT i WILL DO IT AGAIN

Thanks

--

LSC
--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 20 2011 - 09:45:31 CDT