RE: Purge RECYCLEBIN by *age*

From: Chitale, Hemant K <Hemant-K.Chitale_at_sc.com>
Date: Thu, 20 Feb 2014 11:38:13 +0800
Message-ID: <0BDF2A25A09ADD40908745EEFC0A0FB6016D2EEF_at_HKMGAXMB103A.zone1.scb.net>

OK, let me admit : It is been my suspicion that Oracle may choose to auto-extend a datafile rather than purge the recyclebin. Guess this needs to be tested.  

Hemant K Chitale    

From: Maris Elsins [mailto:elmaris_at_gmail.com] Sent: Wednesday, February 19, 2014 11:35 PM To: Chitale, Hemant K
Cc: Niall Litchfield; ORACLE-L
Subject: Re: Purge RECYCLEBIN by *age*  

Hi,  

> That allows me to have the datafiles to not autoextend to a very large
value - in a development environment.  

From the same document: "Oracle(r) Database Backup and Recovery Basics 10g Release 2 (10.2)"
http://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr004.htm#i1 019426
<http://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr004.htm#i 1019426>

        For AUTO EXTEND-able tablespaces, objects are purged from the recycle bin to reclaim space before datafiles are extended.

Do you observe a different behavior in your environment? Which version/platform it is?

---

Maris Elsins

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

www.facebook.com/maris.elsins

 

 

 

On Wed, Feb 19, 2014 at 3:53 AM, Chitale, Hemant K
<Hemant-K.Chitale_at_sc.com> wrote:

No, I cannot guarantee that an object will be available from the
recylcebin for a week.  However, I can assure that no object will
persist in the recyclebin for more than a week.  That allows me to have
the datafiles to not autoextend to a very large value - in a development
environment.

 

Hemant K Chitale

 

 

From: Niall Litchfield [mailto:niall.litchfield_at_gmail.com] 
Sent: Tuesday, February 18, 2014 8:36 PM
To: elmaris_at_gmail.com
Cc: Chitale, Hemant K; ORACLE-L
Subject: Re: Purge RECYCLEBIN by *age*

 

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 


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.

 


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.
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 20 2014 - 04:38:13 CET