look up the sql_text
select t.sql_text
from v$process s, v$session n,v$sqltext t
where s.spid=18740
and n.PADDR = n.PADDR
and n.SQL_ADDRESS=t.ADDRESS order by t.ADDRESS[@more@]
from v$process s, v$session n,v$sqltext t
where s.spid=18740
and n.PADDR = n.PADDR
and n.SQL_ADDRESS=t.ADDRESS order by t.ADDRESS[@more@]
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/9907339/viewspace-1038000/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- luoguP2947 [USACO09MAR] Look Up S
- look look C#7C#
- ORA-600/ORA-7445/ORA-700 Error Look-up Tool的使用方法Error
- look-into-oracle-redoOracle
- very important -have a LookImport
- DB2LOOK 命令DB2
- Oracle如何根據SQL_TEXT生成SQL_IDOracleSQL
- V$sql_text v$sqlarea v$sql 的區別SQL
- db2look相關操作DB2
- wake up
- Level Up
- Look and Feel---JAVA介面（換膚術）Java
- A Brief Look at C++ 中文版 (轉)C++
- 學習 DB2LOOK 命令（轉）DB2
- day day up
- Linux基礎命令---顯示文字lookLinux
- Linux基礎命令—文字顯示lookLinux
- YOLO(You Only LOOK Once)論文詳讀YOLO
- LOOK 直播活動地圖生成器方案地圖
- Backing up the tailAI
- Incremental checkpoint up to RBAREM
- Gross up by wage typeROS
- E. Level Up
- 《Look Mom, I don’t use Shellcode》議題解析
- Introduction to pinatrace annotate version 2: a look into latches againAI
- DB2 db2look的使用方法DB2
- A Look Inside J2EE Patterns(2) (轉)IDE
- A Look Inside J2EE Patterns(3) (轉)IDE
- A Look Inside J2EE Patterns(4) (轉)IDE
- A Look Inside J2EE Patterns(5) (轉)IDE
- Speed Up Your WordPress Site
- UP還是敏捷方法？敏捷
- How to set up printers for GUI?GUI
- Set up the Android SDKAndroid
- set up the appropriate environmentAPP
- 高動態HDR影片調色預設 HDR Look Effects
- Clean up a failed CRS installAI
- NSSCTF Web 題解 Write upWeb