Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: fast refresh for materialized views is too slow
On 10 Feb 2004 08:41:06 -0800, mikeeria_at_interia.pl (Michael) wrote:
> sort_area_size = 104857600
What strikes me you have a sort_area_size of 100M. My feeling says there is something seriously wrong and your request is the result of prolonged symptom fighting. I have never ever seen a sort_area_size of 100M was necessary.
-- Sybrand Bakker, Senior Oracle DBAReceived on Tue Feb 10 2004 - 12:17:22 CST