both store that info
SQL desc v$statname
Name Null?Type
-
STATISTIC# NUMBER
NAME
but only v$sysstat has the value column ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
v$sysstat has the NAME column also?
From: Hately, Mike (LogicaCMG) [EMAIL PROTECTED]
Date: 2003/11/26 Wed AM 08:34:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: when do you use v$statname?
v$statname is a lookup table for the statistic# that appears in
right, then why do we have v$statname?
From: Jamadagni, Rajendra [EMAIL PROTECTED]
Date: 2003/11/26 Wed AM 08:44:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: when do you use v$statname?
but only v$sysstat has the value column ...
Raj
Ryan,
V$sysstat is system wide statistics. It contains name, value and
statistic# and class.
V$statname is used mostly as a lookup.
V$sesstat is session stats which does not contain the *statistic name*
column.
When joined with v$statname (statistic# column), the statistic name
and values can
You are right, that v$statname is not needed when querying v$sysstat,
since v$sysstat has name column.
But, if you look at v$sesstat:
SQL describe v$sesstat;
Name
SID
STATISTIC#
VALUE
Good point. I'd forgotten that. Just a lookup for v$sesstat then.
Cheers,
Mike
-Original Message-
Sent: 26 November 2003 13:39
To: Multiple recipients of list ORACLE-L
both store that info
SQL desc v$statname
Name Null?Type
Hi!
Lookup from v$statname must also be used for v$px_sesstat..
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 26, 2003 4:34 PM
Good point. I'd forgotten that. Just a lookup for v$sesstat then.
Cheers,
Mike