Re: Oracle Row size

I have tables that size. Oracle doesn't have a problem.

I strongly suggest partitioning, even if somehow all 192M are active. If you are going to get any performance at all, you better have indexes. If you partition, the indexes can be local (depending on keys, etc), saving i/o as in when the indexes automatically rebalance, as would the table partitions themselves. You definitely want to avoid table scans if possible.

Also, put each partition in it's own tablespace (maybe with it's indexes, maybe not, depending on size, media etc.) and make it locally managed if possible.

If the data has any 'significant' variability (update/delete), I would avoid clustering.

In article <3a2936e4.20431268_at_125.0.0.1>,   lfc_at_zoom.co.uk (Leonard F Clark) wrote:
> Faheem's right: Oracle can cope. I think the question he's implying
> is: "Can your users?" And, to help them do so, you have some design
> thinking to do.
>
> I'm not so sure that clustered indexes are the only (or even the best)
> approach but, how you implement a large table depends on the nature of
> the data. (Note also that how large this table is depends on the row
> length as well as number of rows: if each row is only, say, 20 bytes,
> then you may not have too much trouble anyway.)
>
> If most of your data is inactive and you only tend to access the tail
> of the table, think about partitioning of one form or another. If you
> are going to be performing low-cardinality selects, you certainly do
> need to think about indexes - but, if the size implies high volumes of
> inserts, there may be a trade-off needed here.
>
> Len
>
> >I am designing our database model for oracle and one of my tables
 will
> >potentially be having more than around 192000000 rows. Do you think
> >oracle could handles this ?
> >
> >Thanks in advance.
> >
> >Sachin.
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
>

--
Joseph R.P. Maloney, CCP,CSP,CDP
MPiR, Inc.
502-451-7404
some witty phrase goes here, I think.


Sent via Deja.com http://www.deja.com/
Before you buy.