oracle 열려진 statement 확인

select sid, count(*) cnt from v$open_cursor
where user_name = 'username'
group by sid
order by cnt desc

각 Statement의 query문 확인

select * from v$open_cursor