Re: AWR logical reads question

From: Karl Arao <karlarao_at_gmail.com>
Date: Fri, 17 Aug 2012 08:47:09 -0500
Message-ID: <CACNsJncXvb0R08+=jx6Vs6LP7J15uZMCm69UVgQEOLU0Sz1bXg_at_mail.gmail.com>

Check out the sample AWR here http://goo.gl/x7fXS that total should come from "session logical reads" then divide it by the object.. then you'll get the percentage..

session logical reads                     6,050,561       10,033.0

2,383.1

• LINEITEM table / session logical reads
• 4,960,400/6,050,561
• 0.819824806327876

Segments by Logical Reads                  DB/Inst: IVRS/ivrs  Snaps:
338-339


-> Total Logical Reads:       6,050,561

-> Captured Segments account for 101.7% of Total

           Tablespace                      Subobject  Obj.       Logical
Owner         Name    Object Name            Name     Type         Reads

 %Total

---------- ---------- -------------------- ---------- ----- ------------
-------
TPCH       TPCHTAB    LINEITEM                        TABLE    4,960,400
81.98
TPCH       TPCHTAB    ORDERS                          TABLE      502,768
 8.31
TPCH       TPCHTAB    PARTSUPP                        TABLE      161,968
 2.68
TPCH       TPCHTAB    PART                            TABLE       95,984
 1.59
TPCC       USERS      STOCK_I1                        INDEX       91,984
 1.52
          -------------------------------------------------------------

-- 
Karl Arao
karlarao.wordpress.com
karlarao.tiddlyspot.com


--
http://www.freelists.org/webpage/oracle-l

Received on Fri Aug 17 2012 - 08:47:09 CDT