查询当前oracle执行那些sql-凯发app官方网站

sql> col username for a30;
sql> col machine for a30;
sql> set linesize 160;
sql> select username,machine,sid,sql_id,status,prev_sql_id,logon_time from v$session where username='system';

username                       machine                               sid sql_id        status   prev_sql_id   logon_tim
------------------------------ ------------------------------ ---------- ------------- -------- ------------- ---------
system                         workgroup\simos                       519               inactive 8f1sjvfxuup9w 21-sep-11
system                         dm01db02.xjods.com                    765 cmn1wnr79nxsu inactive cmn1wnr79nxsu 21-sep-11
system                         workgroup\simos                      1390               inactive 9m7787camwh4m 21-sep-11
system                         dm01db01.xjods.com                   2146               active   7z2rh3s0t3zy2 21-sep-11

sql> select sql_id,sql_fulltext from v$sql where sql_id='7z2rh3s0t3zy2';

sql_id        sql_fulltext
------------- --------------------------------------------------------------------------------
7z2rh3s0t3zy2 begin
              for i in 1..99999999 loop
              execute immediate 'select * from dba_objects';

阅读(1593) | 评论(0) | 转发(1) |

上一篇：软件质量属性包括哪些

下一篇：gdb 条件断点

给主人留下些什么吧！~~

| | | | |

感谢所有关心和支持过chinaunix的朋友们