Re: Recyclebin usage
Date: Fri, 20 Jan 2017 18:17:56 +0000
Message-ID: <MWHPR10MB1680D11DC69E7A10760811FFD8710_at_MWHPR10MB1680.namprd10.prod.outlook.com>
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_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Neil Chandler <neil_chandler_at_hotmail.com> Sent: Friday, January 20, 2017 12:06 PM
To: JBECKSTROM_at_gcrta.org; niall.litchfield_at_gmail.com 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_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Niall Litchfield <niall.litchfield_at_gmail.com> Sent: 20 January 2017 16:04
To: JBECKSTROM_at_gcrta.org
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_at_gcrta.org<mailto:JBECKSTROM_at_gcrta.org>> 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
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 20 2017 - 19:17:56 CET