Re: Next Extent Greater than the free space

On Fri, 18 Jun 1999 11:19:18 +0530, Anurag Minocha <anurag_at_synergy-infotech.com> wrote:

>Hi,
>
>Some of my segments in the system ,Index,User tablespaces have their
>next extent greater than the available free space. What should i do to
>prevent any mishap. Please suggest me something
>
>anurag
>
>reply at
>anurag_at_synergy-infotech.com
>

Hi,

you can create a script to adjust the next clause of the storage parameter:

set trimspool on
set echo off
set term off
set head off
set lines 999
set pages 0
spool doit.sql
select 'alter '||s.segment_type||' '||
  s.owner||'.'||s.segment_name||' storage (next '||   m.maxbytes||' pctincrease 0);'
from dba_segments s,
  (select tablespace_name,max(bytes) maxbytes   from dba_free_space group by tablespace_name) m where s.tablespace_name=m.tablespace_name; ! vi doit.sql
@doit.sql
exit

but i would prefer not to do it automatically. Try to find out, which storage clauses need adjustment by looking at the application(s) and the tablespaces. Keep in mind how often you want to think about fragmentation.

Fred Stojentin Received on Fri Jun 18 1999 - 05:08:00 CDT