RE: Re: wierd runstats_pkg report
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 25 Mar 2004 10:46:36 -0500
Hmm..I stand corrected.
I could have sworn that I read somewhere that statistics numbers were constant
across versions. However, a quick check of 8iR3 and 9iR2 manuals on tahiti
specifically states that they can and will change.
I think I'm losing my mind,
-Mark
-----Original Message-----
From: Wolfgang Breitling [mailto:breitliw@xxxxxxxxxxxxx]
Sent: Thursday, March 25, 2004 10:11 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Re: wierd runstats_pkg report
"Note that unlike latch numbers, the statistics numbers are invariant
across Oracle versions"
That's not entirely true. Some of the statistic# have changed with
Oracle10g for example. Granted, "CPU used by this session" is still 12, but
"physical reads" is now 48 (was 40 in 9i), etc.
I think it is still a good idea to join to v$statname.
At 11:50 PM 3/23/2004, you wrote:
>For CPU time, you just need statistic #12, CPU used by this
>session. (Note that unlike latch numbers, the statistics numbers are
>invariant across Oracle versions, so, I know that 12 is CPU used by this
>session, regardless of what version you're on.) Only V$SYSSTAT has the
>NAME column built in, so if you're using V$SESSTAT or V$MYSTAT, you'll
>have to join to V$STATNAME.
>
>Hope that helps,
>
>-Mark
>
>PS It's 'Cary Millsap', not 'Carrie Milsap'.
Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
