verun

scripts>verun

 

set pagesize 9000
select
a.sid,
a.serial# sid,
a.username,
a.machine,
a.program,
a.status,
b.event,
b.seconds_in_wait
from v$session a,
v$session_wait b
where b.sid = a.sid
and a.username is not null
and status = ‘ACTIVE’
order by b.seconds_in_wait;

Comment

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