Re: disable recyclebin?

From: Nuno Souto <dbvision_at_iinet.net.au>
Date: Wed, 20 Apr 2011 18:57:28 +1000
Message-ID: <4DAE9FF8.1080005_at_iinet.net.au>

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

Received on Wed Apr 20 2011 - 03:57:28 CDT