Oracle目前使用者SQL

標籤：io   ar   sp   on   html   ad   line   size   bs   

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 = 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