Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Slow exports Oracle 8.1.7.0 & 4 and " alter system flush shared_pool "

Slow exports Oracle 8.1.7.0 & 4 and " alter system flush shared_pool "

From: Ton <76434.1353_at_compuserve.com>
Date: 17 Sep 2002 01:08:08 -0700
Message-ID: <4477604.0209170008.78b701fb@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US