Wikipedia

Search results

Thursday 3 July 2014

Capturing html output from SQL Queries

spool /tmp/check.html 
set markup html on 
set echo on 
select to_char(sysdate,'hh24:mi'), username, program , a.sid, a.serial#, b.name, c.value from v$session a, v$statname b, v$sesstat c where b.STATISTIC# =c.STATISTIC# and c.sid=a.sid and b.name like 'redo%' order by value; 
SELECT s.sid, s.serial#, s.username, s.program,i.block_changes FROM v$session s, v$sess_io i WHERE s.sid = i.sid ORDER BY 5 desc, 1, 2, 3, 4; 
SELECT s.sid, s.serial#, s.username, s.program,t.used_ublk, t.used_urec FROM v$session s, v$transaction t WHERE s.taddr = t.addr ORDER BY 5 desc, 6 desc, 1, 2, 3, 4; 
set markup html off 
spool off 

No comments:

Post a Comment