Re: disable recyclebin?

From: <TESTAJ3_at_nationwide.com>
Date: Wed, 20 Apr 2011 05:11:03 -0400
Message-ID: <OF886F2C78.062D3532-ON85257878.0032682F-85257878.003273E8_at_lnotes-gw.ent.nwie.net>



Nuno, don't you have concern about inadvertent drops of tables?

joe



Joe Testa, Oracle Certified Professional Senior Engineering & Administration Lead (Work) 614-677-1668
(Cell) 614-312-6715

From:
Nuno Souto <dbvision_at_iinet.net.au>
To:
oracle-l_at_freelists.org
Date:
04/20/2011 04:58 AM
Subject:
Re: disable recyclebin?
Sent by:
oracle-l-bounce_at_freelists.org

And that's one of the reasons why recycle bin is disabled in all my dbs.

-- 
Cheers
Nuno Souto
in overcast Sydney, Australia
dbvision_at_iinet.net.au



Chitale, Hemant Krishnarao wrote,on my timestamp of 20/04/2011 1:27 PM:

> When the database is under severe pressure to drop and create segments,
the
> presence of recyclebin may sometimes cause ORA-1652's because the
> 'auto-clearance' of the recyclebin isn't fast enough.
>
> I've seen that twice.
>
> See Oracle Support Article "***Bug 6977045 - ORA-1652 even though there
is
> sufficient space in RECYCLE BIN [ID 6977045.8]*"
>
> and read the text for Bug 6977045-- there's a short explanation of a
design
> decision on "extend or wait"
>
> Hemant K Chitale
>
> ***From:*oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]***On Behalf
Of*TESTAJ3_at_nationwide.com
> ***Sent:*Tuesday, April 19, 2011 9:55 PM
> ***To:*Oracle-L_at_freelists.org
> ***Subject:*disable recyclebin?
>
>
> I'm getting push to disable the recyclebin on a 10.2.0.4 database?
>
> I'm pushing back that its not a good idea to disable it for the entire
database
> but to disable for the session or do a drop table <table_name> purge
instead.
>
> Your thoughts?
>
> thanks, joe
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 20 2011 - 04:11:03 CDT

Original text of this message