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
2、通过spid 查找对应SQL:
-- 1、通过spid查找对应内存地址:
SELECT addr FROM v$process c WHERE c.spid = 1560 ;
-- 2、通过内存地址寻址hash值:
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、通过hash值找到对应sql_id:
select a.sql_text,a.sql_id From v$sqltext a where a.hash_value='3838526855' and a.address='00000004DBAE9638' order by piece;
-- 4、通过sql_id查找详细的sql查询脚本:
select SQL_TEXT,SQL_FULLTEXT,SQL_ID,LOADS,FIRST_LOAD_TIME,PLSQL_EXEC_TIME,