Posts Tagged ‘Query to find sessions’

Query to find sessions generating more Archives

April 27th, 2015, posted in Oracle Queries
Share

This Query is to find the session that is generating more Archives.

 

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;
Share