Re: Extents - Full or Max?
From: Mark Vandenbroeck <mvandenb_at_be.oracle.com>
Date: 18 Jan 1995 11:13:20 GMT
Message-ID: <3fit4g$dc5_at_dcsun4.us.oracle.com>
Date: 18 Jan 1995 11:13:20 GMT
Message-ID: <3fit4g$dc5_at_dcsun4.us.oracle.com>
joelga_at_rossinc.com (Joel Garry) wrote:
>
>
> Thanks to all who responded to my message, here and in e-mail. The
> problem turned out to be...[cue drum roll]...
>
> SMON!
>
> 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 Received on Wed Jan 18 1995 - 12:13:20 CET