I am in the process of upgrading my DB from 11107 -> 11203. I already upgraded my test
machine to 11203 and my prod machine is still running 11107.
I took the v$sql from both machines and created tables
create table test_sql as select * from v$sql
create table prod_sql as select * from v$sql
I am running this query to see the differences
select a.sql_id, a.plan_hash_value
from c0harpa.prod_sql a, c0harpa.test_sql b
a.sql_id = b.sql_id and
a.plan_hash_value <> b.plan_hash_value
group by a.sql_id, a.plan_hash_value;
What column/(s) can I use in the v$sql table to show if plan has gotten better or worse?
Would COST column work?
If somebody can provide an example it would be greatly appreciated.
BTW, We don't have RAT, which I know is much easier so that is why I am going the round about
Thanks to all who answer