| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: performance impact
Roger
This is an extra-cost option available only with Oracle Enterprise
Edition.
Since they get extra money for it, Oracle is very generous with marketing
material. Check at http://technet.oracle.com. Also the Oracle manuals are
online at this site so you can read what the manual has to say.
Basically, partitioning allows you to divide a large table into smaller physical tables. This can make them more manageable. Imagine your 400-gig table holds 5 years of data. Each year you would like to add a new year of data and remove the oldest year. With a regular table this would take a long time. With partitioning, you can store each year in a partition and just truncate the oldest year. Many maintenance tasks are easier with partitioning.
If your application performs full table scans of this data, if the partition key is part of the WHERE clause, Oracle can perform query rewrite and just scan the partition(s) with the data needed to satisfy your query.
You can also partition the indexes on a partitioned table.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Monday, April 28, 2003 5:12 PM
To: Multiple recipients of list ORACLE-L
What is Oracle's partitioning option?
-----Original Message-----
Sent: Monday, April 28, 2003 4:42 PM
To: Multiple recipients of list ORACLE-L
Roger
Are you using Oracle's partitioning option? Worth a thought for something this large. If you are going to put all datafiles on the same device, I don't think it matters. Personally I'd go for fewer, larger files just so there is less typing, therefore less chance of error.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Monday, April 28, 2003 4:02 PM
To: Multiple recipients of list ORACLE-L
For a 400 GB tablespace, which one is better?
[64-bit Oracle 9i on Solaris 9]
Thanks,
>
> Roger Xu
> Database Administrator
> Dr Pepper Bottling Company of Texas
> (972)721-8337
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu INET: roger_xu_at_dp7uptx.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ________________________________________________________________________ This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.com ________________________________________________________________________ ________________________________________________________________________ This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.com ________________________________________________________________________ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu INET: roger_xu_at_dp7uptx.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: DWILLIAMS_at_LIFETOUCH.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Apr 28 2003 - 19:36:36 CDT
 |
 |