Re: sql_trace filtering

Hi Mikhail,

that looks great!
Do you know of any other values we can compare? (e.g. action, module, client_id)
Or more generic: where did you get the username() from?

thank you,
 Martin

Am Di., 21. Dez. 2021 um 16:59 Uhr schrieb Mikhail Velikikh < mvelikikh_at_gmail.com>:

> 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
>
> Yes, of course, for example, you can specify a filter by process: ospid or
>> orapid or pname:
>>
>
> You cannot filter by username with the process filter.
>
> On Tue, 21 Dec 2021 at 15:39, Sayan Malakshinov <xt.and.r_at_gmail.com>
> wrote:
>
>> Hi Adric,
>>
>> Yes, of course, for example, you can specify a filter by process: ospid
>> or orapid or pname:
>>
>> {process: ospid <string>[20],
>> orapid <ub4>,
>> pname <string>[20],
>> con_id <ub8> }
>>
>>
>> http://orasql.org/2021/05/20/oracle-diagnostic-events-cheat-sheet/
>>
>>
>> http://orasql.org/files/events/doc/event/filter/oradebug-doc-event-filter-process.php
>>
>>
>>
>> On Tue, Dec 21, 2021 at 6:30 PM Gogala, Mladen <gogala.mladen_at_gmail.com>
>> wrote:
>>
>>> *CAUTION: This email has originated from an extremely suspect and
>>> sometimes very grumpy sender. Proceed with extreme caution and use the
>>> Force.*
>>> On 12/21/2021 10:14 AM, Adric Norris 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.
>>>
>>> Thanx!
>>>
>>> Hi Adric!
>>>
>>> You can create on logon trigger for the specified user and use "ALTER
>>> SESSION" instead of "ALTER SYSTEM".
>>>
>>> Regards
>>> --
>>> Mladen Gogala
>>> Oracle DBA
>>> Tel: (347) 321-1217
>>> Blog: https://dbwhisperer.wordpress.com
>>>
>>
>>
>> --
>> Best regards,
>> Sayan Malakshinov
>> Oracle performance tuning engineer
>> Oracle ACE
>> http://orasql.org
>>
>

-- 
Martin Berger                Oracle ♠
martin.a.berger_at_gmail.com _at_martinberx <https://twitter.com/martinberx>
^∆x      http://berxblog.blogspot.com

--
http://www.freelists.org/webpage/oracle-l