Re: sql_trace filtering

Hi Martin,

Mikhail maybe will add more details, I'll just say about username():

Username is an action from library rdbms: http://orasql.org/files/events/doc/event/action/oradebug-doc-event-action-username.php You can find other actions with `oradebug doc event action` command: http://orasql.org/files/events/oradebug-doc-event-action.php

Best regards,
Sayan Malakshinov
Oracle performance tuning expert
Oracle Database Developer Choice Award winner Oracle ACE
http://orasql.org

ср, 22 дек. 2021 г., 19:29 Martin Berger <martin.a.berger_at_gmail.com>:

> 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