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.
Reg,
An
Other related posts:
