Same query execution plan is different in 2 databases
Hi all,
I have below query and execution plan details. The query in second database is very slow. I find the excution plan is defferent. Any action I can go to fix it? Thanks.
select se.status, se.type, se.sid, se.serial#, se.username, se.osuser, se.machine, se.terminal, se.program, se.module, se.last_call_et, sq.sql_text from v$session se
left outer join v$sql sq on decode(se.sql_address,'00',se.prev_sql_addr,se.sql_address)=sq.address
and decode(se.sql_hash_value,0, se.prev_hash_value, se.sql_hash_value)=sq.hash_value