Can we find out who sent a compliance request?

[Anderson]

I've found the right request:

SELECT s.*
  FROM v$sql s 
 WHERE SQL_TEXT like '%BLABLA%';

How do you know what OS the user sent him to perform?

[Amritpal]

No, in general, it's impossible to find out.

An audit should be included in order to track compliance at the user-specific OBD level. You can start acquainting with a chapter. https://docs.oracle.com/en/database/oracle/oracle-database/21/dbseg/part_6.html Documents.

If 100 per cent of the reliability is not required, it may be ascertained which sessions are active with the user of the OBD system, who has dissolved the SQL request, i.e., with a high probability, the first to request compliance. But it is clear that several user OSs can be connected under one user:

select /*BLABLA*/ * from dual;
select

q.first_load_time, q.parsing_user_id, s.sid, osuser, machine, process

from v$sql q, v$session s, v$process p

where regexp_like (q.sql_text, '/*BLABLA')

and user#=parsing_user_id

and p.addr=s.paddr;
FIRST_LOAD_TIME     PARSING_USER_ID        SID OSUSER MACHINE  PROCESS

2021-11-06/12:26:13             110         48 oracle dbsrv    30465

2021-11-06/12:26:13             110        311 me     clnt123  4176