It is very application dependent and specific. What could be useful in one
situation may be harmful for other cases.
In our dev environment, applications drop/recreate tables on a regular basis.
Some of them are done by the regression tests, thousands of objects/day.. So
all my dev/qa environments have recyclebin turned off.
Of course if someone does something accidentally, I can easily recover from
another copy of the dev databases (we have more than one dev/qa env).
-Upendra
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Neil Chandler <neil_chandler@xxxxxxxxxxx>
Sent: Friday, January 20, 2017 12:06 PM
To: JBECKSTROM@xxxxxxxxx; niall.litchfield@xxxxxxxxx
Cc: oracle-l-freelists; oracle-db-l
Subject: Re: Recyclebin usage
I switch it off for:
- Development Database, especially with a full drop/re-create cycle via
automated deployment. "Hey, DBA's, why is login so slow?" "You have 100,000
tables in your recyclebin"
- If you had an ORA-600 or -7445 investigation, Oracle Support used to ask you
to turn it off (which is a restart). In 10G it was a major cause of the
ORA-600's. 11G Less so. Not seen it in 12C.
Oracle defaults are usually the best place to start. Change only to make things
better for a specific, defined and empirically provable reason (not because you
googled it and it seems to help).
Neil Chandler
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Niall Litchfield <niall.litchfield@xxxxxxxxx>
Sent: 20 January 2017 16:04
To: JBECKSTROM@xxxxxxxxx
Cc: oracle-l-freelists; oracle-db-l
Subject: Re: Recyclebin usage
We do.
What version are you on? I'm struggling to understand why you would disable
this feature now.
On Fri, Jan 20, 2017 at 1:19 PM, Beckstrom Jeffrey
<JBECKSTROM@xxxxxxxxx<mailto:JBECKSTROM@xxxxxxxxx>> wrote:
Do you use the recycle bin yes or no and why? We are considering disabling it
and are interested in the communities thoughts before doing so.
Jeffrey Beckstrom
Lead Database Administrator
Information Technology Department
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
--
Niall Litchfield
Oracle DBA
http://www.orawin.info