select * from v$session g, v$sqltext t
where g.SQL_ADDRESS = t.ADDRESS
and g.SQL_HASH_VALUE = t.HASH_VALUE
and g.USERNAME = 'SYSTEM'
posted on 2010-08-04 18:36  懒懒的呐喊  阅读(89)  评论(0编辑  收藏  举报