Re: Re: Text Index Create takes forever
Date: Mon, 25 Nov 2019 15:53:19 +0100 (CET)
Message-ID: <117750027.31016.1574693599118_at_bluewin.ch>
HI Jonathan,
yes, I thought of it too. Of course the index will become less efficient. BTW: was there not any preference to start a sync job on commit? I can' t find it ...
Regards
Lthar
----Ursprüngliche Nachricht----
Von : jonathan_at_jlcomp.demon.co.uk
Datum : 25/11/2019 - 15:37 (MN)
An : oracle-l_at_freelists.org
Betreff : Re: Text Index Create takes forever
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
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 25 2019 - 15:53:19 CET