Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: users
I could just tell you to use the v$sessions veiw but that would be to easy, try this script (note some statistic#'s might be different on your version of Oracle)
-Ethan
http://www.freetechnicaltraining.com/article_10.htm
http://www.gnumetrics.com
select
nvl(s.username, ' ') "User Name",
nvl(osuser, ' ') "OS User",
s.sid "SID", type "Type", s.serial# "Serial#",
sum(decode(ss.statistic#, 40, ss.value, 0)) "Physical Reads", sum(decode(ss.statistic#, 41, ss.value, 0)) "Physical Writes", sum(decode(ss.statistic#, 39, ss.value, 0)) "Consistent Gets", sum(decode(ss.statistic#, 162, ss.value, 0)) "Session DiskSorts",
trunc(sum(decode(ss.statistic#, 155, ss.value/1024000, 0)), 2) "MB Sent To Client SQL Net", trunc(sum(decode(ss.statistic#, 156, ss.value/1024000, 0)),2) "MB Rec From Client SQL Net"
v$sesstat ss, v$statname sn, v$session s
Got questions? Get answers over the phone at Keen.com.
Up to 100 minutes free!
http://www.keen.com
Received on Wed Jul 12 2000 - 00:00:00 CDT