sql_trace filtering
From: Adric Norris <landstander668_at_gmail.com>
Date: Tue, 21 Dec 2021 09:14:58 -0600
Message-ID: <CAJueESpT3UG4s1z1brZ248qCH+vOYEa3CmSgsjcc=9zfK0OAnA_at_mail.gmail.com>
One of our applications has several accounts running identical SQL, and I need to trace one of these statements for a single user in order to troubleshoot an issue.I know we can enable tracing of specific SQL IDs using something like:
Date: Tue, 21 Dec 2021 09:14:58 -0600
Message-ID: <CAJueESpT3UG4s1z1brZ248qCH+vOYEa3CmSgsjcc=9zfK0OAnA_at_mail.gmail.com>
One of our applications has several accounts running identical SQL, and I need to trace one of these statements for a single user in order to troubleshoot an issue.I know we can enable tracing of specific SQL IDs using something like:
alter system set events 'sql_trace[sql:8d6bc5134y9h7] ...'
Is it possible to add a filter for user ID/name as well? I've been searching, but can't seem to find any examples of this if so.
Thanx!
-- "In the beginning the Universe was created. This has made a lot of people very angry and been widely regarded as a bad move." -Douglas Adams -- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 21 2021 - 16:14:58 CET