Re: Preventing delayed block cleanout due to loading a datawarehouse
Date: Fri, 08 Apr 2011 21:14:12 GMT
Message-ID: <4d9f7a77.2236531_at_news.hetnet.nl>
On Fri, 08 Apr 2011 21:02:28 GMT, j.w.vandijk.removethis_at_hetnet.nl (Jaap W. van Dijk) wrote:
>Hi,
>
>I'm in charge of a datawarehouse which we update every weekend. That
>means loading lots of tables with
>
>TRUNCATE
>INSERT /*+ APPEND PARALLEL */ ... SELECT ... FROM ...
>COMMIT
>
>for every table. The volume of the total load is about half to one TB.
>
>Afterwards, when the tables are queried, every now and again an
>ORA-01555 happens, sometimes even after days. In my opinion this can
>only be because of delayed block cleanout, because loading and then
>querying a table is *always* done serially.
>
>If I would load the tables with
>
>DROP TABLE
>CREATE TABLE ... AS SELECT ... FROM ...
>
>would the blocks be written pre-cleaned out, thus preventing the
>ORA-01555 from happening?
>
>Regards,
>Jaap.
Oops, forgot the version: 9.2.0.8 on VMS. Received on Fri Apr 08 2011 - 16:14:12 CDT