摘要: select a.sid,a.blocking_session,a.last_call_et,a.event,object_name,dbms_rowid.rowid_create(1,data_object_id,rfile#,ROW_WAIT_BLOCK#,ROW_WAIT_ROW#) "rowid" ,c.sql_text,c.sql_fulltextfrom v$session a,v$sqlarea c ,dba_objects,v$datafilewhere a.blocking_session is not nulland a.sql_hash_value = 阅读全文
posted @ 2012-12-21 13:36 立伟 阅读(15856) 评论(0) 推荐(0) 编辑