Permalink Submitted by dave on Wed, 10/03/2012 - 13:43.
Hmm, that is odd. I went round and round with many client tools like SQL*Plus, SQL Developer, Toad and they all gave me different SQL IDs for the same cut and pasted simple queries as noted in my post here http://ba6.us/sql_id_by_any_other_name . Going through OEM was the only way I could get things to match up. I wish there was a "Normalized SQL ID" available for all the SQL that Oracle sees so we could get past this and make sure we are talking about the same SQL!
As far as timing out and restarting, not sure I can be much help there. OEM is a fickle beast.
Hmm, that is odd. I went
Hmm, that is odd. I went round and round with many client tools like SQL*Plus, SQL Developer, Toad and they all gave me different SQL IDs for the same cut and pasted simple queries as noted in my post here http://ba6.us/sql_id_by_any_other_name . Going through OEM was the only way I could get things to match up. I wish there was a "Normalized SQL ID" available for all the SQL that Oracle sees so we could get past this and make sure we are talking about the same SQL!
As far as timing out and restarting, not sure I can be much help there. OEM is a fickle beast.