Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: About ORA-01658 unable to create INITIAL extent for segment in tablespace <ts>
Howard J. Rogers wrote:
> Mark Bole wrote:
>
>> Howard J. Rogers wrote: >> >>> Marck wrote: >>> >>>> Hi Gurus, >>>>[...]
>> You don't plan to use it, but it's very convenient to get through the >> unexpected emergency so you have more time to deal with the underlying >> problem.
>> I haven't tried resumable statements -- I suppose they are an >> alternative, but with more drawbacks than AUTOEXTEND (as in, you have >> to explicitly set them up, and they still don't allow an operation to >> complete until there is some intervention).
It reminds me of a script that ran daily on an Oracle 6 database I worked with. It saved and reported a six-month history of tablespace growth, determined whether or not any table or index segment would be unable to allocate its next extent based on an analysis of contiguous free space and pct_increase, and even had an option to eliminate "honeycombs". All we had to do was remember to actually look at the report every day and intervene when indicated!
Nowadays I can just run "Tablespace Analysis" in OEM. If we purchased the OEM option packs and spent the time to set up the various space management event tests, I could be back just about where I was 12 years ago ;-)
--Mark Bole Received on Mon May 10 2004 - 10:24:23 CDT