RE: Re: wierd runstats_pkg report

  • From: <ryan.gaffuri@xxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 24 Mar 2004 9:40:26 -0500

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@xxxxxxxxxxxxxxx>
> Date: 2004/03/24 Wed AM 01:50:34 EST
> To: <oracle-l@xxxxxxxxxxxxx>
> 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@xxxxxxx]
> Sent: Tue 3/23/2004 5:01 PM
> To:   oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxx>
> To: <oracle-l@xxxxxxxxxxxxx>
> 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@xxxxxxxxxxxxx
> > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of ryan.gaffuri@xxxxxxx
> > Sent: Tuesday, March 23, 2004 2:46 PM
> > To: oracle-l@xxxxxxxxxxxxx
> > 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@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: