Re: reclaiming space from recycle bin

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • Date: Wed, 9 Dec 2009 16:59:01 -0800

That database now has undo_retention set to 86400 and
an appropriate amount of UNDO space.

The 900 second default isn't too useful when you get a
call the next day...

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com



On Wed, Dec 9, 2009 at 11:01 AM, Niall Litchfield <
niall.litchfield@xxxxxxxxx> wrote:

> Also select * from .... As of timestamp is very useful.
>
> On 12/9/09, Niall Litchfield <niall.litchfield@xxxxxxxxx> wrote:
> > It doesn't get purged, but space is eligible for reuse, so you can
> > rely on getting that data back as many times as you like, until you
> > actually need to when it will have been overwritten;-(
> >
> > On 12/9/09, Jared Still <jkstill@xxxxxxxxx> wrote:
> >> Interesting, I did not recall that.
> >>
> >> As I am currently recovering a database to clone so as
> >> to retrieve a single row, I don't have time to look this up:
> >>
> >> Does the recycle bin get purged automatically if the space
> >> is needed?
> >>
> >> I know, I should already know that...
> >>
> >> Jared Still
> >> Certifiable Oracle DBA and Part Time Perl Evangelist
> >> Oracle Blog: http://jkstill.blogspot.com
> >> Home Page: http://jaredstill.com
> >>
> >>
> >>
> >> On Wed, Dec 9, 2009 at 8:14 AM, Allen, Brandon
> >> <Brandon.Allen@xxxxxxxxxxx>wrote:
> >>
> >>>  This is documented behavior:
> >>>
> >>>
> >>>
> >>>
> >>>
> http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/flashptr004.htm#sthref615
> >>>
> >>>
> >>>
> >>> “Recycle bin objects are not counted as used space. If you query the
> >>> space
> >>> views to obtain the amount of free space in the database, objects in
> the
> >>> recycle bin are counted as free space.”
> >>>
> >>>
> >>>
> >>> Regards,
> >>>
> >>> Brandon
> >>>
> >>>
> >>>
> >>> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> >>> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of
> >>> *Sharon.Kovac@xxxxxxxxxxxxxxx
> >>>
> >>> There was no change in dba_free_space after I purged the recycle bin.
> >>>
> >>>
> >>> ------------------------------
> >>> Privileged/Confidential Information may be contained in this message or
> >>> attachments hereto. Please advise immediately if you or your employer
> do
> >>> not
> >>> consent to Internet email for messages of this kind. Opinions,
> >>> conclusions
> >>> and other information in this message that do not relate to the
> official
> >>> business of this company shall be understood as neither given nor
> >>> endorsed
> >>> by it.
> >>>
> >>
> >
> > --
> > Sent from my mobile device
> >
> > Niall Litchfield
> > Oracle DBA
> > http://www.orawin.info
> >
>
> --
> Sent from my mobile device
>
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>

Other related posts: