Awr Units?
From: Kenneth Naim <kennaim_at_gmail.com>
Date: Fri, 22 May 2009 10:27:33 -0400
Message-ID: <00d601c9dae9$739e0220$5ada0660$_at_com>
Many of the Statistics on a 10gR2 AWR do have units listed and while most are self explanatory or can be assumed quite easily, I was wondering if anyone could point me to a document that spelled out each statistic and it's appropriate unit. Logical Reads, Physcial Reads/Writes are examples of stats without units and while I assume them to all be db blocks, a single physical read could be multiple db/os blocks depending on how it is defined.
Date: Fri, 22 May 2009 10:27:33 -0400
Message-ID: <00d601c9dae9$739e0220$5ada0660$_at_com>
Many of the Statistics on a 10gR2 AWR do have units listed and while most are self explanatory or can be assumed quite easily, I was wondering if anyone could point me to a document that spelled out each statistic and it's appropriate unit. Logical Reads, Physcial Reads/Writes are examples of stats without units and while I assume them to all be db blocks, a single physical read could be multiple db/os blocks depending on how it is defined.
A metalink and google search has not yielded any results as of yet.
My college professors always said "A number is meaningless unless it has units".
Thanks,
Ken
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 22 2009 - 09:27:33 CDT