SELECT sid, schemaname, osuser, substr(machine, 1, 20) Machine FROM v$session ORDER BY schemaname; SELECT sql_text FROM v$sqlarea WHERE (address, hash_value) IN (SELECT sql_address, sql_hash_value FROM v$session WHERE sid = &1);
阅读(495) | 评论(0) | 转发(0) |