Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 32412 invoked from network); 11 Jan 2008 03:53:13 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-69-64-49-119.inaddr.intergenia.de with SMTP; 11 Jan 2008 03:53:13 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 32FEB7E2321; Fri, 11 Jan 2008 04:53:13 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11633-04; Fri, 11 Jan 2008 04:53:13 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 98D7B7E1068; Fri, 11 Jan 2008 04:53:12 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 11 Jan 2008 04:05:18 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 076C67E296B for ; Fri, 11 Jan 2008 04:05:18 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 07861-06 for ; Fri, 11 Jan 2008 04:05:17 -0500 (EST) Received: from mx3.Kocbank.com.tr (SMTPIN.kocbank.com.tr [195.46.132.130]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2B3F67E160A for ; Fri, 11 Jan 2008 04:05:06 -0500 (EST) Received: from camexc1.kfs.local ([10.222.8.20]) by MX3.yapikredi.com.tr with InterScan Message Security Suite; Fri, 11 Jan 2008 11:04:17 +0200 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C85431.079D6319" Subject: RE: explain plan, can you explain this? Date: Fri, 11 Jan 2008 11:04:51 +0200 Message-ID: <083667B535F3464CA0DD0D1DAFA4E3760F667B4B@camexc1.kfs.local> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: explain plan, can you explain this? References: <617957.71921.qm@web35403.mail.mud.yahoo.com> <2ead3a60801092008u765893bdj39d77bd58c8e9a1d@mail.gmail.com> <083667B535F3464CA0DD0D1DAFA4E3760F6673C2@camexc1.kfs.local> <2ead3a60801100936h201540e6nf1c6db35ae0dda65@mail.gmail.com> From: "Yasin Baskan" To: "Andrew Kerber" , Cc: , "Oracle L" X-archive-position: 4504 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: yasin.baskan@yapikredi.com.tr Precedence: normal Reply-to: yasin.baskan@yapikredi.com.tr List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------_=_NextPart_001_01C85431.079D6319 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Andrew, AWR reports delta values, not cumulative statistics. =20 It reports the delta values from the columns of dba_hist_sqlstat like buffer_gets_delta. =20 Here is a part of an sql run by a 10.2 awrrpt.sql =20 ... sum(disk_reads_delta) dskr, sum(executions_delta) exec, =20 sum(cpu_time_delta) cput, sum(elapsed_time_delta) elap ... from dba_hist_sqlstat where dbid =3D :dbid and instance_number =3D :inst_num =20 and :bid < snap_id and snap_id <=3D :eid group by sql_id) ... =20 From: Andrew Kerber [mailto:andrew.kerber@gmail.com]=20 Sent: Thursday, January 10, 2008 7:57 PM To: john.kanagaraj@gmail.com Cc: Yasin Baskan; dannorris@dannorris.com; Oracle L Subject: Re: explain plan, can you explain this? =20 And then, you have to do it again for AWR. AWR does report cumulative statistics. On Jan 10, 2008 11:36 AM, John Kanagaraj wrote: > John, are you sure that statspack reports sql statistics cumulatively? Yasin and Allen, You are right: My bad. STATSPACK indeed does report the differences. This myth of mine was self-created, probably from early days of STATSPACK. Thank you for setting me right. This reminds me once more=20 to re-validate everything I know. Regards, -- John Kanagaraj <>< DB Soft Inc http://www.linkedin.com/in/johnkanagaraj=20 http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!) ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers **=20 -- http://www.freelists.org/webpage/oracle-l --=20 Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'=20 ------_=_NextPart_001_01C85431.079D6319 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

Andrew, AWR reports delta values, not cumulative = statistics.

 

It reports the delta values from the columns of = dba_hist_sqlstat like buffer_gets_delta.

 

Here is a part of an sql run by a 10.2 = awrrpt.sql

 

...

sum(disk_reads_delta) dskr, sum(executions_delta) = exec,

 

         &nbs= p;            = sum(cpu_time_delta) cput, sum(elapsed_time_delta) elap

...

from dba_hist_sqlstat

         &nbs= p;        where = dbid

      =3D = :dbid

         &nbs= p;          and = instance_number =3D :inst_num

 

          = and = :bid            = < snap_id

         &nbs= p;          and = snap_id

   <=3D :eid

         &nbs= p;     group by sql_id)

...

 

From: Andrew Kerber [mailto:andrew.kerber@gmail.com]
Sent: Thursday, January 10, 2008 7:57 PM
To: john.kanagaraj@gmail.com
Cc: Yasin Baskan; dannorris@dannorris.com; Oracle L
Subject: Re: explain plan, can you explain = this?

 

And then, you have = to do it again for AWR.  AWR does report cumulative = statistics.

On Jan 10, 2008 11:36 AM, John Kanagaraj <john.kanagaraj@gmail.com = > wrote:

> John, are you = sure that statspack reports sql statistics cumulatively?

Yasin and Allen,

You are right: My bad. STATSPACK indeed does report the differences.
This myth of mine was self-created, probably from early days of
STATSPACK. Thank you for setting me right. This reminds me once more =
to re-validate everything I know.

Regards,

--
John Kanagaraj <><
DB Soft Inc
http://www.linkedin.com/in/johnkanagaraj
http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!)
** The opinions and facts contained in this message are entirely = mine
and do not reflect those of my employer or customers **
--
http://www.freelists.org/webpage/oracle-l




--
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

------_=_NextPart_001_01C85431.079D6319-- -- http://www.freelists.org/webpage/oracle-l