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 -> Re: Weird performance issue ....

Re: Weird performance issue ....

From: Chuck <skilover_nospam_at_softhome.net>
Date: Wed, 05 Oct 2005 10:17:08 -0400
Message-ID: <1128517570.8eb155db67f3d7d41979e75e3d149027@bubbanews>


IANAL_VISTA wrote:
> vigneaua_at_hotmail.com wrote in
> news:1128358667.441376.284140_at_f14g2000cwb.googlegroups.com:
>
>

>>The customer is running many other application running on Oracle. I
>>have to assume that the configuration is been well taken care of.
>>
>>The customer tends to think the problem is script related, he does not
>>seem to retain the fact that it runs very well on our DEV box. I have
>>to find a way to prove that the problem is not script base.
>>
>>Thanks
>>

>
>
> It might help to (re)compute statistics after the import.
> Then again, it might not.
> It can't hurt to try.

Depending on what was specified for STATISTICS= on both the export and the import it could make a huge difference. So could a missing index which is why I suggested checking the import log for errors.

-- 
To reply by email remove "_nospam"
Received on Wed Oct 05 2005 - 09:17:08 CDT

Original text of this message

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