Re: How much does it cost to run Enterprise Oracle on Linux?

So it does, and the quote is still there in the relevant 10.2 concepts
manual as well. i'd point you at
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96520/parpart.htm#97896instead.
11m is many millions, but I doubt many would consider 2 to be a
valid value for many Gb. It seems to me that a table of 11m rows may benefit
from partitioning to be honest, though i bet it would work better with smart
indexing and more processors with parallelism. Definitely worth a test as
you may just be paying too much for the worng options...

On 10/30/06, laura pena <lizzpenaorclgrp@xxxxxxxxx> wrote: 

It does say tables greater than 2gb should always be considered.


http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c12parti.htm#459787

This table is is select, inserted and updated too very often.

Many Thanks,
Lizz

*"Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>* wrote:

I've got 11GB tables that aren't partitioned and I have no problems.
Where did you see the 2GB recommendation?  I thought I saw a recommendation
for 4GB before (in the S.A.M.E document maybe?), but I don't remember
seeing 2GB.  I would suggest that it doesn't matter so much how big the
table is as how it is used.  If you perform queries that could benefit from
partition scans vs. full table scans, or if you need the ability to add and
drop large amounts of data, e.g. quarterly sales data in a warehouse or
something like that - those are where I would look at partitioning.
Parallelism works just fine on a regular table - no need for partitioning to
support parallelism.  Oracle will logically partition it among the parallel
processes automatically.

 ------------------------------
*From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *laura pena

Our largest table holds 11 millions rows. If we expect to grow that is
great, but Oracle reccomends to start partition a table when the table
reaches 2g or more in size.

Is that what everyone else has as a rule of thumb.

Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions
and other information in this message that do not relate to the official
business of this company shall be understood as neither given nor endorsed
by it.


------------------------------
Low, Low, Low Rates! Check out Yahoo! Messenger's cheap PC-to-Phone call
rates.<http://us.rd.yahoo.com/mail_us/taglines/postman8/*http://us.rd.yahoo.com/evt=39663/*http://voice.yahoo.com>




--
Niall Litchfield
Oracle DBA
http://www.orawin.info

Other related posts: