Showing posts with label useful Queries. Show all posts
Showing posts with label useful Queries. Show all posts

Tuesday, November 6, 2012

Query to find sessions generating more Archives

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

col program for a10

col username for a10
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;