Re: Text Index Create takes forever

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

Since it's going to be a killer anyway. hash partition about 16 or 32 ways while you move it.

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:37:42 CET