Re: Oracle aborts monitoring a long running statement - how to find the reason

  • From: Sayan Malakshinov <xt.and.r@xxxxxxxxx>
  • To: Stefan Koehler <contact@xxxxxxxx>
  • Date: Wed, 6 Dec 2017 11:37:40 +0300

Hi Thomas,

I use own script for such cases:
https://github.com/xtender/xt_scripts/blob/master/rtsm/sqlid_manual.sql
Despite the fact that oracle changes status to "DONE(ERROR)", it still
keeps updating v$sql_plan_monitor, so you can get values from it manually

Other related posts: