Ah, yes, sorry, misread user id as process id. My bad
Best regards,
Sayan Malakshinov
Oracle performance tuning expert
Oracle Database Developer Choice Award winner
Oracle ACE
http://orasql.org
вт, 21 дек. 2021 г., 18:59 Mikhail Velikikh <mvelikikh@xxxxxxxxx>:
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@xxxxxxxxx>
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@xxxxxxxxx>
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
