Help - Search - Members - Calendar
Full Version: ERP is running slow after cloning
Oracle DBA Forums > Oracle > Oracle Forum
Hi all,

We have done cloning of our ORACLE APPLICATION(11i),after that performance of ERP is getting slow (like fetching of data).

Please suggest what we can do to increase the performance.

Hi Dbal,

>> We have done cloning of our ORACLE APPLICATION(11i),

1 - Make sure that you migrated the statistics for the optimizer and/or re-analyze schema stats:


Tuning is a complex subject, start here:

If you want details get the scripts from the online code depot of this book:
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2015 Invision Power Services, Inc.