Re: Purge RECYCLEBIN by *age*

This is what I was referring to by posting that statement. From "Oracle® Database Backup and Recovery Basics 10g Release 2 (10.2)" http://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr004.htm#i1019426

>
> *7.4.6.2 How the Database Responds to Space Pressure*When space pressure
> arises, the database selects objects for automatic purging from the recycle
> bin. *Objects are selected for purging on a first-in, first-out basis,
> that is, the first objects dropped are the first selected for purging*.
> Actual purging of objects is done only as needed to meet ongoing space
> pressure, that is, the databases purges the minimum possible number of
> objects selected for purging to meet immediate needs for space. This policy
> serves two purposes:
> - It minimizes the performance penalty on transactions that encounter
> space pressure, by not performing more purge operations than are required;
> - It maximizes the length of time objects remain in the recycle bin, by
> leaving them there until space is needed.

Strange, but I couldn't find the same statements in 11.2 documentation.

---
Maris Elsins
_at_MarisElsins <https://twitter.com/MarisElsins>
www.facebook.com/maris.elsins




On Tue, Feb 18, 2014 at 2:36 PM, Niall Litchfield <
niall.litchfield_at_gmail.com> wrote:



> Maris

>

> I don't believe that to be *always* true, even in the form which I suspect

> you meant (they will be purged automatically starting with the oldest ones

> in the tablespace in which you require free space), AFAIK the blocks

> involved are free to be reused as and when a space allocation occurs, I

> don't believe there is any mechanism which prioritizes the extent

> allocation by age.

>

> Hemant

>

> What are you hoping to achieve with this? A guarantee that an object can

> be recovered for a week after it is dropped?

>

>

>

>

> On Tue, Feb 18, 2014 at 9:28 AM, Maris Elsins <elmaris_at_gmail.com> wrote:

>

>> Hi,

>>

>> Why would you want to purge them?

>> They will be purged automatically started with the oldest ones when free

>> space is needed.

>>

>> To answer the question, I think it's not possible unless you write a

>> script that queries the objects that you want to be purged from

>> dba_recyclebin and then purging them one by one.

>>

>> ---

>> Maris Elsins

>> _at_MarisElsins <https://twitter.com/MarisElsins>

>> www.facebook.com/maris.elsins

>>

>>

>>

>>

>> On Tue, Feb 18, 2014 at 11:18 AM, Chitale, Hemant K <

>> Hemant-K.Chitale_at_sc.com> wrote:

>>

>>>   Is it possible to Purge the RECYCLEBIN by age  ?  --- e.g. remove

>>> those objects that were DROPped 7 days ago.  That way, a periodic cleanup

>>> of the RECYCLEBIN can be done and yet objects may be available for recovery

>>> for 7 days.

>>>

>>> Hemant K Chitale

>>>

>>>

>>> This email and any attachments are confidential and may also be

>>> privileged. If you are not the intended recipient, please delete all copies

>>> and notify the sender immediately. You may wish to refer to the

>>> incorporation details of Standard Chartered PLC, Standard Chartered Bank

>>> and their subsidiaries at

>>> https://www.sc.com/en/incorporation-details.html.

>>>

>>

>>

>

>

> --

> Niall Litchfield

> Oracle DBA

> http://www.orawin.info

>


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