Re: top sessions ?

From: Vitaliy Mogilevskiy <vit100gain_at_earthlink.net>
Date: Tue, 06 Apr 1999 10:40:10 -0700
Message-ID: <370A46FA.C3C19946@earthlink.net>

You can use this join:

select username, terminal, name, value
from v$statname n,
v$session s,
v$sesstat t
where s.sid=t.sid

and n.statistic# = t.statistic#
and s.type = 'USER'
and s.username is not NULL
and n.name = 'session pga memory'
and t.value > &use_at_least_30000


+--------------------------------------------------------------------------+

| Vitaliy Mogilevskiy
| Senior Consultant
| CORE Technology Group, Inc.
| E-mail:    vit100gain_at_earthlink.net
| Web Page:  http://home.earthlink.net/~vit100gain/index.html

|            *** Free DBA Script Library at my Web Page ***
|

| "Never wrestle a pig - you both get dirty and the pig likes it..." | "If the only tool you have is a hammer, everything looks like a nail..."

+--------------------------------------------------------------------------+

Jan-Marten Spit wrote:

> Hi yall,
>
> How would you determine the top N sessions on an Oracle instance (using
> V$SESSTAT)
>
> Will looking at the consistent gets (statistic# 39) give an accurate
> picture?
>
> for example,
>
> select
> sid,
> value
> from
> v$sesstat
> where
> statistic#=39
> order by value desc
>
> Any ideas for a formula combining statistics from V$SESTAT that gives an
> accurate picture?
>
> Read you,
>
> Jan-Marten Spit

-- Received on Tue Apr 06 1999 - 12:40:10 CDT