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 l
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 Da
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
:)
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 appe
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 ar
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
-
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
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 b
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?
>
>
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$statnam
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 !
--
both store that info
SQL> desc v$statname
Name Null?Type
-
STATISTIC# NUMBER
NAME VARCHA
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 in
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 reci
This view seems to be a smaller subset of v$sysstat? When is it useful?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: <[EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mai
15 matches
Mail list logo