oracle 在windows系统中通过spid查找执行的sql-ocpyang
---方法1F:\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 ThdHnd Priv CPU Time Elapsed Time
oracle 1552 846 1128 3078612 4:08:11.403 954:35:19.610
pslist -dmx 1552
1363936 8 139 Wait:UserReq0: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
页:
[1]