Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: db_file_mutliblock_read_count and physical IO

Re: db_file_mutliblock_read_count and physical IO

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 19 Aug 2004 09:47:21 +0100
Message-ID: <7765c897040819014735a29f40@mail.gmail.com>


On Wed, 18 Aug 2004 11:54:33 -0500, Cary Millsap <cary.millsap_at_hotsos.com> wrote:
> I think it's important to realize that even the Oracle Reference manual =
> is
> subtly wrong in two ways.

<snip>
> The errors:
>
> 1. It's not just data blocks. It's index blocks, undo blocks, and so on.
> It's Oracle blocks.

<pet rant>

I'm not sure I count this as an *error* - sure it is a common way of looking at things DATA vs INDEX tablespaces anyone? It might even be the accepted term and so we will probably have to live with it, but to my mind data is data regardless of the type of logical object it belongs to. An index contains data, an undo segment contains data, the stored code of for example packages contains data. The only blocks to my mind that do not contain data are empty blocks. Unless the reading of empty blocks is also counted (which it might be I'm ignorant on this) then I don't like the distinction in this case. I'd say that the documentation was subtly correct and the rest of us were wrong.  

</pet rant>

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Aug 19 2004 - 03:43:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US