Understanding Oracle Table Partitioning

Session ID:

1062

Presenter(s):

Lewis Cunningham

More and more, as DBAs are required to spend more time on business activities and less on design, the burden of designing databases falls to developers. It is important for developers to understand the best methods to access data, especially as databases, in general, are getting larger. Oracle 11g has enhanced many of these methods and one of the most important is partitioning.

Oracle Partitioning spreads data out allowing a more granular access. In addition to easing manageability of the data, partitioning may increase performance of large data sets and, in the right circumstances, partitioning will enhance availability.

This presentation will explain, in development terms, what partitioning is, how it works, how and when to use it, and the benefits that 11g can provide. Topics discussed will be:

Partitioning Types
Range
List
Hash
Composite Types
Sub-Partitions

Interval Partitions

Reference Partitions in 11g

Creating Partitions & Sub-Partitions

Indexing Partitioned Tables

Partition Maintenance & Statistics

Partition Keys and Partition Pruning

When to use Partitioning

This presentation is based on my real world usage of partitioning and on my podcast (sponsored by Oracle) on VLDB and Partitioning (updated for 11g).

http://blogs.ittoolbox.com/oracle/guide/archives/oracle-buzz-episode-3-v...

Schedule info

Time slot:

21 July 14:30 - 15:25

Room:

Virtual Room # 200

Session Objectives:

Presentation attendees will leave the presentation understanding what partitioning really is, how it can help them do their day to day job, and when it makes sense to use partitioning to solve problems.

Track/Stream:

Database - Oracle

Category:

Conference Session

Group:

360 Degree Overview

Session Length:

60 Minutes

Status:

Accepted

Target Audience:

All

Posted by lewiscunningham Mar 08, 2011

Stalk VirtaThon @

Like VirtaThon?

LIVE Activity Stream

Ha Dinh Thang signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace

19 hours ago
Yohan signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace

1 day ago
nilanjan signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace

1 day ago
HOARAU signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace

1 day ago
Hany Abdo signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace

1 day ago
Jimmy Coran signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace

1 day ago
AMIT DUTTA signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace

1 day ago
shyamkumar signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace

2 days ago

Quick Poll

Are you excited about the advent of VirtaThon?

Top Members

Scroll To Top

About BrainSurface | The Collaborative ConnectSpace for Oracle, Java & MySQL Professionals

BrainSurface is the most Powerful, Advanced & Extensible ConnectSpace for Oracle, Java & MySQL professionals and is built on and driven by the following themes:

Next-Generation Social Networking

State-of-the-Art IT Collaboration

BrainSurface is broadly aimed at sharing, collaborating and reusing all the edges of technology and technical/functional knowledge that, we come accross in our professional lives within the generalized realm of the Oracle, Java & MySQL communities. BrainSurface is the FIRST of its kind in bringing Social Networking and ALL known collaborative paradigms under one roof for this very purpose: Online Virtual Conferencing, Webinars & Webcasts, Social Collaboration, Document Publishing, Blogging in all its variant forms, Videos, Discussions, Forums, Job Repository, Project Management and a whole lot more. All Collaboration and Social Networking components within BrainSurface are bleeding-edge, intuitive and feature-rich. Best of all: membership at BrainSurface is 100% FREE!

Disclaimer: VirtaThon and BrainSurface are not affiliated or supported by Oracle Corporation and its affiliates/subsidiaries. Oracle, Java, MySQL and others are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.