Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re: wierd runstats_pkg report

RE: Re: wierd runstats_pkg report

From: <ryan.gaffuri_at_cox.net>
Date: Wed, 24 Mar 2004 9:40:26 -0500
Message-Id: <20040324144026.WWZB10550.lakemtao08.cox.net@smtp.central.cox.net>


i was hoping for some short articles for how to derive meaning behind some of those views. Oh well, Ill dig it up on metalink.
>
> From: "Bobak, Mark" <Mark.Bobak_at_il.proquest.com>
> Date: 2004/03/24 Wed AM 01:50:34 EST
> To: <oracle-l_at_freelists.org>
> Subject: RE: Re: wierd runstats_pkg report
>
> Not sure what you mean by "how to use". It's cumulative data, up to the current point in time.
>
> So, look at V$SESSTAT for any given SID, and take a snapshot. Then, monitor the session doing it's work, and when it's done, take another snapshot. Subtract the values from the first snap from their corresponding values in the second snap, and you'll have statistics info for the duration of the window.
>
> It's very similar to what StatsPack does and what Tom Kyte's RunStats package does.
>
> 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'.
>
> -----Original Message-----
> From: Ryan [mailto:ryan.gaffuri_at_cox.net]
> Sent: Tue 3/23/2004 5:01 PM
> To: oracle-l_at_freelists.org
> Cc:
> Subject: Re: Re: wierd runstats_pkg report
> can someone point me to some good articles(other than the docs) on how to
> use the v$stat.. etc... views and such? Have any of you written any? Same
> with stuff on v$thread.
>
> The docs arent very clear. I've got Carrie Milsap's tuning book, but havent
> had time to read it cover to cover. Alot of that is in there.
> ----- Original Message -----
> From: "Jamadagni, Rajendra" <Rajendra.Jamadagni_at_espn.com>
> To: <oracle-l_at_freelists.org>
> Sent: Tuesday, March 23, 2004 3:42 PM
> Subject: RE: Re: wierd runstats_pkg report
>
>
> > v$mystat ... statistic is 'CPU used by this session'
> >
> > Raj
> > --------------------------------------------------------------------------
> ------
> > Rajendra dot Jamadagni at nospamespn dot com
> > All Views expressed in this email are strictly personal.
> > select standard_disclaimer from company_requirements;
> > QOTD: Any clod can have facts, having an opinion is an art !
> >
> >
> > -----Original Message-----
> > From: oracle-l-bounce_at_freelists.org
> > [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of ryan.gaffuri_at_cox.net
> > Sent: Tuesday, March 23, 2004 2:46 PM
> > To: oracle-l_at_freelists.org
> > Subject: Re: Re: wierd runstats_pkg report
> >
> >
> > which view do i get cpu usage from?
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://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_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://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_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Mar 24 2004 - 08:39:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US