Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: CTX_DDL question
Hi,
Given the amount of sorting work Oracle has to do, I always found that
increasing SORT_AREA_SIZE and SORT_AREA_RETAINED size helped.
Regards
Pete
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of rjamya
Sent: 20 December 2004 13:30
To: Oracle Discussion List
Subject: CTX_DDL question
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