Need help on query performance issue

  • From: "Shastry(DBA)" <shastry17@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 1 Oct 2009 13:14:00 +0530

Hi Gurus,
I have Oracle query which runs fine in production and test1 server but
taking more time in the recently cloned two more dev servers. i checked for
explain plan and got that two tables are having FULL TABLE SCANS  and didnt
find anything FTS issue in production and test1 servers with the same data.
I did analyze two databases completely to have latest stats collection but
didnt help :(.
How to tackle this issue please guide.
Thanks in advance.


Other related posts: