Database Tuning (MOSC)

MOSC Banner

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 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center