Re: Re: Re: Text Index Create takes forever

From: <l.flatz_at_bluewin.ch>
Date: Mon, 25 Nov 2019 17:13:44 +0100 (CET)
Message-ID: <193171026.36541.1574698424084_at_bluewin.ch>

HI Janathan,

thanks.

Regards

Lothar
----Ursprüngliche Nachricht----
Von : jonathan_at_jlcomp.demon.co.uk
Datum : 25/11/2019 - 16:26 (MN)
An : oracle-l_at_freelists.org
Betreff : Re: Re: Text Index Create takes forever

Lothar,

I have an example showing

parameters ('sync (on commit)')

as the syntax for sync on commit, and a note that there was a bug with this until 12.2 (bug #24589262 : $R CONTENTION DURING COMMIT)

Regards
Jonathan Lewis

---

From: l.flatz_at_bluewin.ch <l.flatz_at_bluewin.ch> Sent: 25 November 2019 14:53
To: Jonathan Lewis
Cc: oracle-l_at_freelists.org
Subject: Re: Re: Text Index Create takes forever

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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Nov 25 2019 - 17:13:44 CET