historical sql statement executed completely or aborted?
i have a sql in Cursor cache/AWR history which is not currenlty running....is there a way i can find if the query was executed completely (without any interruption) or aborted for any reason(may be db shutdown/session killed).
The reason i would like to know this is i have a query which has many plan hash values and each plan hash value related to query has different elapsed time.....and when we run a SQLT extract on that sql_id it shows if the query is good or bad based on elapsed time ..but that query might be aborted not have completely run...and we perceive it to be a good plan which actually we dont know..