RE: Flashback database log sizing

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Radoulov, Dimitre Sent: 20 September 2006 10:56
To: oracle-l_at_freelists.org
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

--
http://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
==============================================================================

--
http://www.freelists.org/webpage/oracle-l