Oracle – Connections hanging

How to find what connections are hanging?

select 	sess.username,	sess.sid,sess.serial#, stat.value cursors, machine
from	v$sesstat stat
,	v$statname sn
,	v$session sess
where	sess.username like '%db user name%'
and	sess.sid = stat.sid
and	stat.statistic# = sn.statistic#
and	sn.name = 'opened cursors current'
order by machine

For more inforamtion visit http://www.shutdownabort.com/dbaqueries/Administration_Session.php

-0-

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s