首页 > 代码库 > Oracle当前用户SQL
Oracle当前用户SQL
select sesion.sid,
sesion.serial#,
sesion.username,
sesion.sql_id,
sesion.sql_child_number,
optimizer_mode,
hash_value,
address,
sql_text
from v$sqlarea sqlarea, v$session sesion
where sesion.sql_hash_value = http://www.mamicode.com/sqlarea.hash_value
and sesion.sql_address = sqlarea.address
and sesion.username is not null;
打印sql html
set linesize 1000
set trimspool on
set term off verify off feedback off pagesize 999
set markup html on entmap on spool on
set echo off
spool /tmp/html1.html replace
select * from table;
spool off
set markup html off
set echo on
-------------------
AVAST:C63088777H1200A0413-AZHFEZ79
Oracle当前用户SQL
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。