Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Slow exports Oracle 8.1.7.0 & 4 and " alter system flush shared_pool "
I have send this problem earlier but want to come back on it.
We have installed several Oracle databases on different location and
hardware. IBM / Compaq
I red a lot about export problems performance problems on the net but
not mine.
What is the case: Normally the exports performed well dumps of 700 MB in 4 minutes but frequently the exports slows down and the same quantity of data takes 2 hours. After a few days the export performes suddenly normal again (4 minutes)
I have these slow exports frequently and they also disappear as they
come.
Yesterday I had again a extremely slow export and I flushed the SGA
during the export. " alter system flush shared_pool" The export
startsto perform again on full speed immediatly !!
Is there a negative aspect using the " alter system flush shared_pool " command before the export. Are there any realy negative consequences using the command? Received on Tue Sep 17 2002 - 03:08:08 CDT