SQL Performance (MOSC)

MOSC Banner

historical sql statement executed completely or aborted?

edited Jul 5, 2016 10:54AM in SQL Performance (MOSC) 6 commentsAnswered ✓

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..

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