Re: Flashback database
From: Saibabu Devabhaktuni <saibabu_d_at_yahoo.com>
Date: Wed, 6 Feb 2013 22:29:34 -0800 (PST)
Message-ID: <1360218574.52918.YahooMailNeo_at_web161306.mail.bf1.yahoo.com>
Hameed,
Flashback database is one of the great features Oracle has ever introduced. If you don't do lots of data purges (i.e. partition maintenance) or dropping and creating big tables, flashback impact is not really noticeable, even otherwise you only see flashback logs requiring more disk space.
Date: Wed, 6 Feb 2013 22:29:34 -0800 (PST)
Message-ID: <1360218574.52918.YahooMailNeo_at_web161306.mail.bf1.yahoo.com>
Hameed,
Flashback database is one of the great features Oracle has ever introduced. If you don't do lots of data purges (i.e. partition maintenance) or dropping and creating big tables, flashback impact is not really noticeable, even otherwise you only see flashback logs requiring more disk space.
Keep in mind that operations like block new for first insert into a block require that block to be read from disk for flashback and same thing goes when HWM for any object is extended by 5 blocks (i.e. all 5 new blocks need to be read from disk).
Thanks,
Sai
http://sai-oracle.blogspot.com
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 07 2013 - 07:29:34 CET