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