Agreed. Tongue firmly in cheek there.
-Original Message-
Sent: 26 November 2003 19:04
To: Multiple recipients of list ORACLE-L
:)
Btw, I advise against memorizing statistic numbers, because they change over
versions...
Tanel.
- Original Message -
To: Multiple recipients of
v$statname is a lookup table for the statistic# that appears in v$sesstat
and v$sysstat. You use it in most queries on those tables unless you're
named Tanel and have memorised the statistic numbers. =)
Cheers,
Mike Hately
-Original Message-
Sent: 26 November 2003 13:24
To: Multiple
doesn't v$statname store the statistics# and statistics_name ... it's like a lookup
table. v$sysstat is the actual values for each of statistic.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed
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 v
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
On Wed, 26 Nov 2003, Hately, Mike (LogicaCMG) wrote:
v$statname is a lookup table for the statistic# that appears in v$sesstat
and v$sysstat. You use it in most queries on those tables unless you're
named Tanel and have memorised the statistic numbers. =)
Remember Oracle likes to change
:)
Btw, I advise against memorizing statistic numbers, because they change over
versions...
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 26, 2003 3:34 PM
v$statname is a lookup table for the statistic# that appears
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
V$SYSSTAT has a NAME attribute. V$SESSTAT doesn't. So seeing the name
when you're using V$SESSTAT requires a join with V$STATNAME.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta
- SQL Optimization 101: 12/8
14 matches
Mail list logo