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: Large table and buffer cache concerns

Re: Large table and buffer cache concerns

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 16 Apr 2007 08:24:17 -0700
Message-ID: <1176737048.803401@bubbleator.drizzle.com>


devalos_at_gmail.com wrote:

> As to the assumption I'm making that a single data block contains only
> the data for a single customer...
> If I am using a single table b*tree cluster and I've configured it to
> only allow the records for a single customer to be stored within a
> single data block, that data block will only contain records
> associated with a single customer.

I'd like to be the guy who sells your storage. <g>

You are talking about the possibility of one record per block.

-- 
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 Apr 16 2007 - 10:24:17 CDT

Original text of this message

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