its not typical/strange to see flashbacklogs occupy more space(just check timestamp of flasback logs produced.....would be kept from long time say 2 to 3 months).oracle says it deletes them when space has to be reclaimed but i never find this valid as we had lot of space issue's because of this logs. i dont think that there is a way to campare the sizes with archivelogs...... -Edwin "Lawie, Duncan" <duncan.lawie@xxxxxxxxxxxxxxxxx> wrote: I was thinking more along these lines ... I have a dev system running in archivelog mode with flashback database on. It appears that the flashback logs are using four times as much space as the archivelogs ... 1* select * from v$flash_recovery_area_usage SQL> / FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES ------------ ------------------ ------------------------- --------------- CONTROLFILE 0 0 0 ONLINELOG 3.91 0 8 ARCHIVELOG 10.58 0 23 BACKUPPIECE 0 0 0 IMAGECOPY 0 0 0 FLASHBACKLOG 43.15 42.72 158 Is this typical? What ratios are others finding? Thanks, Duncan. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Radoulov, Dimitre Sent: 20 September 2006 10:56 To: oracle-l@xxxxxxxxxxxxx Subject: Re: Flashback database log sizing > it might be finger-in-the-air time. Does anyone have sizing > information for flashback database logs? > How do they compare in size with, say, the archive logs created over > the same period? Check the V$FLASHBACK_DATABASE_LOG view (retention_target/estimated_flashback_size). Regards Dimitre -- //www.freelists.org/webpage/oracle-l ============================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html ============================================================================== -- //www.freelists.org/webpage/oracle-l --------------------------------- Do you Yahoo!? Next-gen email? Have it all with the all-new Yahoo! Mail.