Re: Recyclebin usage

I havent found it particularly useful in production. I have run into one use case where it was an actual problem. A user application created several thousand tables per day for temporary usage, and we actually ran into serious performance problems purely from recyclebin management. We did disable the recyclebin for that. Sure, it was an application design issue, but it was a third party application we could not change.

Basically, i am neutral on it. I dont see any particular advantage from using it, or (normally) any real disadvantage.

On Fri, Jan 20, 2017 at 10:09 AM, Jeff Smith <jeff.d.smith_at_oracle.com> wrote:

> So use the drop/purge option – you drop your temp tables, your recycle bin
> doesn’t fill up and it’s reserved for ‘normal’ drops.
>
>
>
> Have your cake, and eat it too.
>
>
>
> *From:* Beckstrom Jeffrey [mailto:JBECKSTROM_at_gcrta.org]
> *Sent:* Friday, January 20, 2017 11:07 AM
> *To:* niall.litchfield_at_gmail.com
> *Cc:* oracle-l-freelists <oracle-l_at_freelists.org>; oracle-db-l <
> oracle-db-l_at_Groups.ITtoolbox.com>
> *Subject:* Re: Recyclebin usage
>
>
>
> We have an application that creates/drops 1000 "temp" tables daily.
>
> >>> Niall Litchfield <niall.litchfield_at_gmail.com> 1/20/17 11:04 AM >>>
>
> 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>
> 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
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

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