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

Home -> Community -> Usenet -> c.d.o.server -> Re: Can anyone explain this huge increase in logical I./O....?

Re: Can anyone explain this huge increase in logical I./O....?

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 23 Oct 2006 14:09:16 -0700
Message-ID: <1161637755.42598@bubbleator.drizzle.com>


mccmx_at_hotmail.com wrote:

>> And the high-water marks?

>
> Why would the HWMs have any bearing...? The table is accessed via
> TABLE ACCESS BY ROWID.
>
> Oracle only reads up to the HWM when reading via Full Table Scan.
> Unless I'm mistaken.
>
> Matt

Perhaps I misread what was posted but I thought the OP was doing full table scans. I'll withdraw my comment.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Oct 23 2006 - 16:09:16 CDT

Original text of this message

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