Can we find out who sent a compliance request?
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?
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;
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')
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