CTX_DDL question

From: rjamya <rjamya_at_gmail.com>
Date: Mon, 20 Dec 2004 08:29:54 -0500
Message-ID: <9177895d0412200529628900b4@mail.gmail.com>

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';

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Dec 20 2004 - 07:25:13 CST