How to get sql text after run
From: Eriovaldo Andrietta <ecandrietta_at_gmail.com>
Date: Sat, 10 Jul 2021 19:39:33 -0300
Message-ID: <CAJdDhaMtZZN45QqaUYzaj1auN1ToCVh+f1zK9EeiVvTV==ACFQ_at_mail.gmail.com>
Hi all,
Eriovaldo
Date: Sat, 10 Jul 2021 19:39:33 -0300
Message-ID: <CAJdDhaMtZZN45QqaUYzaj1auN1ToCVh+f1zK9EeiVvTV==ACFQ_at_mail.gmail.com>
Hi all,
What is the best Oracle 12.2.x view in order to retrieve the full sql_text that ran some hours ago ?
I usually try to get the in the sequence :
GV$SQLAREA
DBA_HIST_ACTIVE_SESS_HISTORY
Is there another view that surely I can get the sql_text using a datetime
interval ?
Regards
Eriovaldo
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Jul 11 2021 - 00:39:33 CEST