oracle通过pid查找执行SQL

通过TOP 命令查看PID:1560

  PID USER      PR  NI    VIRT    RES    SHR S  %CPU %MEM     TIME+ COMMAND                                                         
 1560 oracle    20   0 38.978g 0.038t  16296 R 100.0 15.3   1069:13 python3 Main_Mem.py ProcessLog1 config.ini     

通过spid 查找对应SQL:

1、
   SELECT addr FROM v$process c WHERE c.spid = 1560 ;
2、
   SELECT DECODE (sql_hash_value,
   0, prev_hash_value,
   sql_hash_value
   ),
   DECODE (sql_hash_value, 0, prev_sql_addr, sql_address)
   FROM v$session b
   WHERE b.paddr = '00000004B08F4DC8';

3、
   select a.sql_text,a.sql_id From v$sqltext a where a.hash_value='3838526855 ' and a.address='00000004DBAE9638' order by piece  ;