Re: 10g Recycle Bin

Michael42 wrote:
> Hello,
>
> In Oracle 10g (10.2.02) on Sun Solaris:
>
> 1. Are there any down sides to using the Recycle Bin?

I can only think of upsides to the Recycle Bin. When you drop a table, it is placed in the Bin. This will still have space, but once you need that space, objects in the bin are the first to go.

> 2. Does enabling it require any other services be running concurrently
> (like SMON, PMON services), if so what are the service(s) that support
> its functionality?

There are not background processes necessary for the Recycle Bin. Placing a deleted table in the Bin is done by the user process that issues the DROP TABLE command.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown