Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: memory leak/overuse
Well, a consistent export starting at 10am means 'show me all tables as they
were at 10am, even if it now happens to be 10.30'. So Oracle has to produce
read-consistent images of the data like crazy (meaning that it copies
buffers, and rolls them back to the state they were at at 10am). So data
buffers are being copied left right and centre. Rollback blocks are being
used left right and centre. The buffer cache is therefore going to be awash
with all sorts of buffers that have nothing to do with the current version
of the data. You expect consistent=y to mean that you kiss goodbye to large
swathes of your buffer cache.
Regards
HJR
> Thanks again. I will implement MTS. Will see the result.
> Another finding is:
> Doing consistent export on a table in "recycled" pool reduce number of
> available memory (buff) by 100 MB. Regular export only 10MB
> Do you know any problems with consistent export or recycled poll that
> may do something like that?
>
>
> Thanks
> Leon
Received on Thu May 02 2002 - 18:42:53 CDT