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

I'd say 2GB is just an arbitrary number - I don't know why they would say that. Anyone else have any idea if there is something magical about the 2GB size that would warrant partitioning? Sounds to me like they're just saying that to help with sales of the Enterprise Edition and the partitioning option.  

Frequency of selects, inserts and deletes has nothing to do with partitioning. It all depends on exactly *how* those operations are being performed. For example, if you're doing a bunch of unique index lookups and individual inserts and deletes, partioning isn't going to help at all, but if you're performing full table scans or index range scans that could be broken up by partitions or mass inserts/deletes that could be done in partitions, then it could be a big help.

        From: laura pena [mailto:lizzpenaorclgrp_at_yahoo.com]                  

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

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

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

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.

--
http://www.freelists.org/webpage/oracle-l