RE: Flashback database log sizing
- From: edwin devadanam <edwin_kodamala@xxxxxxxxx>
- To: duncan.lawie@xxxxxxxxxxxxxxxxx
- Date: Wed, 20 Sep 2006 14:41:46 -0700 (PDT)
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.
Other related posts:
