Help - Search - Members - Calendar
Full Version: ERP is running slow after cloning
Oracle DBA Forums > Oracle > Oracle Forum
dbal
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.

thanks,
dbal
burleson
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:

http://www.dba-oracle.com/t_steps_for_orac...ance_tuning.htm

If you want details get the scripts from the online code depot of this book:

http://rampant-books.com/book_1002_oracle_...ence_2nd_ed.htm
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-2014 Invision Power Services, Inc.