RE: Flashback database log sizing

From: edwin devadanam <edwin_kodamala_at_yahoo.com>
Date: Wed, 20 Sep 2006 14:41:46 -0700 (PDT)
Message-ID: <20060920214146.89335.qmail@web52309.mail.yahoo.com>

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_at_credit-suisse.com> 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_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




 				
---------------------------------
Do you Yahoo!?
 Next-gen email? Have it all with the  all-new Yahoo! Mail.
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 20 2006 - 16:41:46 CDT