Re: Recyclebin usage

From: Neil Chandler <neil_chandler_at_hotmail.com>
Date: Fri, 20 Jan 2017 17:06:24 +0000
Message-ID: <AM4PR10MB0145FA22AAC28DBEA0D60A0485710_at_AM4PR10MB0145.EURPRD10.PROD.OUTLOOK.COM>

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
Cleveland, Ohio 44113

--
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jan 20 2017 - 18:06:24 CET