It took .32 seconds on my xe db. I would "grip it and rip it" during off peak times, worse case scenario, it would take very little time to rebuild an xe db from scratch. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Daniel Fink Sent: Tuesday, August 24, 2010 3:11 PM To: Oracle-L@xxxxxxxxxxxxx Subject: RE: Re: Oracle XE Corruption "Probably less time than it takes to replace the differential in my car. :)" Would that be on race day or between races? smon_scn_time table is the table that Oracle uses to keep track of the relationship between scns and timestamps for flashback operations. It -- //www.freelists.org/webpage/oracle-l