oracle total recall

From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Tue, 3 Apr 2012 13:00:50 +0200
Message-ID: <4F7AD862.9030108_at_nordea.com>



hi,

I wonder if anybody used this feature and what are Your impressions?

We turn it on lately on some application and here a little subjective first look:
- enabling it is easy - point A

  • we add data - point B
  • first "restore" of previous state was quite fast - point C, logical state from A
  • then we do a little more changes - point D
  • and flashback again - point E, logical state from C - this time it went really long (ie. few days), which puzzles me - it was 15 min. of changes and flashing them back was longer then creating the database from scratch (ie. import file)

We assumed this is a penalty for not purging total recall data when in C, so the next time I did it (ie. purging). This time it seems to run faster, but I may only dream about the performance of the first time (ie. C). Sure, the database is founded on some test environment, but not so bad, I dare to say, though storage is some RAID5, but still wonder...

I saw that flashback goes with db file sequential reads block by block, so it can not be too fast, but still wonder...

Did anybody notice such characteristic of that feature? Any clever tips or tricks to speed things up (and I do not mean a faster IO susbsystem, more memory and faster CPU, but rather suggestion for example to get rid of flashback archive after every flashback operation and enable it again or truncate somehow flashback archive system tables with drop storage option, because I have noticed the segments after purge are of the same size as before).
Of course there is always an option I did something wrong... (and this would be also good to know)

Best regards
Remigiusz

-- 
Pole nakazi

----------------------------------------------------------------------
Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
pos   : DBA at DIiUSI
addr  : Nordea Bank Polska SA, Luzycka 6A Street, 81-537 Gdynia, Poland
phone : +48 58 667 17 43
mobile: +48 602 42 42 77
Nordea Bank Polska S.A. z siedzibą w Gdyni, ul. Kielecka 2, 81-303 Gdynia, 
wpisaną do Rejestru Przedsiębiorców Krajowego Rejestru Sądowego pod numerem: 0000021828, 
dla której dokumentację przechowuje Sąd Rejonowy Gdańsk - Północ w Gdańsku, 
VIII Wydział Gospodarczy Krajowego Rejestru Sądowego, 
o kapitale zakładowym i wpłaconym w wysokości: 277.493.500,00 złotych, 
NIP: 586-000-78-20, REGON: 190024711--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 03 2012 - 06:00:50 CDT

Original text of this message