---方法1 F:\tool>pslist oracle pslist v1.3 - Sysinternals PsList Copyright (C) 2000-2012 Mark Russinovich Sysinternals - www.sysinternals.com Process information for LOG: Name Pid Pri Thd Hnd Priv CPU Time Elapsed Time oracle 1552 8 46 1128 3078612 4:08:11.403 954:35:19.610 pslist -dmx 1552 1363936 8 139 Wait:UserReq 0:00:00.062 0:00:00.000 0:03:54.858 ---方法2 pslist -d oracle pslist -m oracle SELECT /*+ ORDERED */ sql_text FROM v$sqltext a WHERE (a.hash_value, a.address) IN ( 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 = (SELECT addr FROM v$process c WHERE c.spid = '&pid')) ORDER BY piece ASC / 输入 pid 的值: 1363936 原值 13: WHERE c.spid = '&pid')) 新值 13: WHERE c.spid = '1363936')) SQL_TEXT ---------------------------------------------------------------- update t1 set sid=123
转载于:https://blog.51cto.com/ocpyang/1213146