Re: CTX_DDL question
- From: Edgar Chupit <chupit@xxxxxxxxx>
- To: rjamya@xxxxxxxxx
- Date: Tue, 21 Dec 2004 08:13:51 +0200
You can read Note:176135.1 to understand what optimze_index really
does and what is the difference between FULL and other modes. If You
can't afford waiting too long You can always execute optimize_index in
small batches by specifying maxtime parameter. As for performance it
really depends on how much inserts/updates did underlying documents
had (how much "suboptimal" index is).
On Mon, 20 Dec 2004 08:29:54 -0500, rjamya <rjamya@xxxxxxxxx> wrote:
> Hi all,
>
> I don't have much experience with ctx_ddl package and how it works. We
> recently tried to perform a FULL optimize on one of context indexes,
> and it took around 20 hours on a slow day.
>
> On a second db, I tried to perform the same operation with
> PARALLEL_DEGREE (a parameter to full optimize procedure) of 8 and the
> process finished in 4 minutes. Since it didn't register anything in
> dr$index_stats, I assume it didn't do anything.
>
> any tricks to speed up this process? 9204/aix5.2ml2/24cpu/32gb
>
> TIA
> Raj
> ------------------------------
> select standard_disclaimer from company_requirements where category =
> 'MANDATORY';
> --
> //www.freelists.org/webpage/oracle-l
>
--
Edgar
--
//www.freelists.org/webpage/oracle-l
Other related posts:
