Question about Oracle Partitioning (When to consider it?)

From: Taylor, Chris David <>
Date: Thu, 17 Dec 2009 14:30:18 -0600
Message-ID: <>

I'm curious if there are any "rules of thumb" about when to consider moving to Oracle partitioning. What warning signs could one look for in a non-partitioned server that might indicate a need for Oracle partitioning?

Our largest table is 2.8GB. I've worked in shops with unpartitioned tables as large as 12GB. (I know some of you work in shops with tables much larger than that)

When considering Oracle partitioning, what questions should be asked before jumping into it?

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799

CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.

Received on Thu Dec 17 2009 - 14:30:18 CST

Original text of this message