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
