Re: Extents - Full or Max?

In article <3fit4g$dc5_at_dcsun4.us.oracle.com> mvandenb_at_be.oracle.com writes:
>
>joelga_at_rossinc.com (Joel Garry) wrote:
>>
>> Turns out, when you drop and re-add a schema/user with the same name,
>> repeatedly, SMON doesn't totally clean up after. So eventually, you run
>> out of space, even though it appears you should have enough contiguous
>> space. The fix is simple - just shut down and restart the database.
>
>As far as I know, there is no such bug known with SMON.
>BUT! SMON does it's cleaning at a very low priority. It may take hours
>or sometimes days (depending on size, system activity, ...) before
>the clean-up is complete.
>
>Mark

To you, Mark (and to Oracle), it's a feature; to Joel, it's a BUG :-)

Philip

--
+---------------------------------+-------------------------------------------+
|Philip Chee: philip_at_aleytys.pc.my| This is a work of fiction.Any resemblance |
|Tasek Cement Berhad              |  to persons living or dead is completely  |
|P.O.Box 254, 30908 Ipoh, MALAYSIA| coincidental. The creator of this article |
|Voice: +605-551-011              |    has asserted its moral right to be     |
|  Fax: +605-566-142              |          identified as the author.        |
 +-------------------Eigi-Eru-Enn-Allir-Jomsvikingar-Daudir!-------------------+