Re: sql_trace filtering

On Tue, Dec 21, 2021 at 9:59 AM Mikhail Velikikh <mvelikikh_at_gmail.com> wrote:

> 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.
>>
>
> Yes, it is indeed possible with a proper syntax, e.g.:
>
> alter system set events 'sql_trace[sql:bqka14bvd2zmb]
> {streq:username(),"TC1"}';
>
> Please see a full Gist:
> https://gist.github.com/mvelikikh/27a488e9104e63a55261c480b70a86f6
>

This looks like exactly what I need. 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-l