RE: Flashback database log sizing
- From: "Lawie, Duncan" <duncan.lawie@xxxxxxxxxxxxxxxxx>
- To: "'cichomitiko@xxxxxxxxx'" <cichomitiko@xxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 20 Sep 2006 12:22:26 +0100
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
Other related posts:
