Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle performance Tuning 10g reference poster
 
Oracle training in Linux commands
 
Oracle training Excel
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
 Reply to this topicStart new topic
> ERP is running slow after cloning
dbal
post Apr 22 2012, 04:29 AM
Post #1


Newbie
*

Group: Members
Posts: 8
Joined: 13-January 12
Member No.: 46,583
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
Go to the top of the page
 
+Quote Post
burleson
post Apr 22 2012, 08:40 AM
Post #2


Advanced Member
***

Group: Members
Posts: 10,430
Joined: 26-January 04
Member No.: 13
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


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
 

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 20th June 2013 - 12:50 AM
Powered By IP.Board 2.3.6 © 2013  IPS, Inc.