使用SqlPlus的客户端来检查,参考信息如下 命令如下:oracle@PerfTestDB4:/home/oracle>sqlnSQL*Plus: Release 10.2.0.3.0 - Production on Thu Aug 28 13:11:47 2008Copyright (c) 1982, 2006, Oracle. All Rights Reserved.@>connect Enter user-name: voucher Enter password: Connected. voucher@VOUCHER>@showsql
SELECT osuser, username, sql_text from v$session a, v$sqltext b where a.sql_address =b.address order by address, piece;
或者用工具,比如toad的sql monitor
如果非本机上,就要用SQL去获得
ORACLE官方网上的文章,参考下:
http://www.oracle.com/global/cn/oramag/oracle/04-sep/o54talking.html
我查查文章
菜单上的"datebase"-"monitor"-"sql monitor"
打开会列出来你当前运行的程序,把要监控的勾上,然后会跟踪出客户端程序所有跑的SQL
这个我经常会用到的,有时间不高兴去查原代码,就用这个跟踪下
;
命令如下:oracle@PerfTestDB4:/home/oracle>sqlnSQL*Plus: Release 10.2.0.3.0 - Production on Thu Aug 28 13:11:47 2008Copyright (c) 1982, 2006, Oracle. All Rights Reserved.@>connect
Enter user-name: voucher
Enter password:
Connected.
voucher@VOUCHER>@showsql