Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: CTX_DDL question

RE: CTX_DDL question

From: Hitchman, Peter <Peter.Hitchman_at_thomson.com>
Date: Tue, 21 Dec 2004 12:14:23 -0000
Message-ID: <8D697B8FCEBB3744B3A1E4AE15E8331E4B88BA@der-lon-msg-03.derwent.co.uk>


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



select standard_disclaimer from company_requirements where category = 'MANDATORY';
--

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

This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email

--

http://www.freelists.org/webpage/oracle-l Received on Tue Dec 21 2004 - 06:09:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US