Re: Flashback database
- From: Saibabu Devabhaktuni <saibabu_d@xxxxxxxxx>
- To: free <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 6 Feb 2013 22:29:34 -0800 (PST)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
