Re: Text Index Create takes forever

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 25 Nov 2019 14:33:01 +0000
Message-ID: <CWXP265MB17500E502C9E64FEF4A5C279A54A0_at_CWXP265MB1750.GBRP265.PROD.OUTLOOK.COM>

Maximise the memory size you allow and add as many words as possible to the STOPLIST, maybe.

Regards
Jonathan Lewis

---

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of l.flatz_at_bluewin.ch <l.flatz_at_bluewin.ch> Sent: 25 November 2019 13:17
To: oracle-l_at_freelists.org
Subject: Text Index Create takes forever

Hi,

we have a 8oo million rows table that we want to migrate to an other Tablespace. The key point is the migration of a Text index based on a BLOB (Secure file) that contains PDF. The recreation of the Index takes weeks. It is CPU bound and the time is spend parsing the BLOB. So far it seems the best Strategy to gfo as high parallel as possible. Any idea to speed this up? DB version is 12.2.0.1.

Regards

Lothar

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

Received on Mon Nov 25 2019 - 15:33:01 CET