Re: AWR logical reads question
- From: Karl Arao <karlarao@xxxxxxxxx>
- To: kmoore@xxxxxxxxxxxx
- Date: Fri, 17 Aug 2012 08:47:09 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
