Re: Oracle aborts monitoring a long running statement - how to find the reason
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Wed, 6 Dec 2017 11:37:40 +0300
Message-ID: <CAOVevU60=EbWmbwjag163FXzLRufhr18-E8T4Ca3Mwtf9VDxjw_at_mail.gmail.com>
Date: Wed, 6 Dec 2017 11:37:40 +0300
Message-ID: <CAOVevU60=EbWmbwjag163FXzLRufhr18-E8T4Ca3Mwtf9VDxjw_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 06 2017 - 09:37:40 CET