Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: fragmentation and index maintainence
In article <40AE0F4B.74FE_at_yahoo.com>, Connor McDonald says...
> >
> > So you use DBMS_JOB to schedule periodic (you say mins) 'sync'
> > instructions - what does this call look like?
> >
> > And as a result of making this change index growth is then proportional
> > to the increase in data stored (as you would expect it to be!).
> >
> > cheers
> >
> > --
> >
> > jeremy
>
> (To answers your final question) its closer...
>
> If you're doing lots of deletes, then it tends to take some significant
> optimize calls (or a full rebuild) to get that space back, but other
> than that, we've been pretty happy with just regular (ie 5min) syncs
>
> The call is just: ctx_ddl.sync_index('index_name')
>
Thanks Connor
-- jeremyReceived on Fri May 21 2004 - 09:53:35 CDT