Hi All,
We have oracle 11.2.0.4 on Aix 7.
One of the sql statement ( only one table ) is taking 12 seconds on Test1 db and the same query took 60 seconds on Test2 Db.
when i checked on test1,test1 has more rows than test2, last analyzed date is Aug-18-2017 in test1 but last analyzed date is Apr-05-2018 in test2.
When i checked explain plan in test1, it use one index but that index is not used in test2,in test2 use parallel process but not using in test1.
sorry,i couldn't share sql statement and explain plan details.
How move that explain plan to one db to another db.I don't have metalink id.
Any Suggestions.
Thanks.