Text Index Create takes forever
From: <l.flatz_at_bluewin.ch>
Date: Mon, 25 Nov 2019 14:17:32 +0100 (CET)
Message-ID: <513805008.24912.1574687852447_at_bluewin.ch>
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
Date: Mon, 25 Nov 2019 14:17:32 +0100 (CET)
Message-ID: <513805008.24912.1574687852447_at_bluewin.ch>
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-lReceived on Mon Nov 25 2019 - 14:17:32 CET