Re: Hints on what to check for bad performance
Hi,
1.for new setup can you rebuild indexes by "OPTIMIZE TABLE <tbl_name>;
for all tables in that DB.
2.for performance analysis take one query & execute on both servers & setup profiler and check where this query spending more time.
Let me know for further analysis
Thanks & Regards,
Chandan
chandankumar9965@gmail.com
Subject
Views
Written By
Posted
1569
September 21, 2015 08:47PM
887
September 21, 2015 10:01PM
Re: Hints on what to check for bad performance
824
September 25, 2015 07:55AM
845
October 02, 2015 09:59PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.