Session ID: 
1062
Presenter(s): 

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

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

Stalk VirtaThon @

  • Facebook Page: 113995341985805
  • FeedBurner: brainsurface
  • Twitter: brainsurface
  • YouTube: brainsurface
  • External Link: paper.li/brainsurface/oracle-java-headlines

Like VirtaThon?

Joomla Templates and Joomla Extensions by JoomlaVision.Com

LIVE Activity Stream

  • flx signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 11 hours ago
  • Krishna signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 1 day ago
  • salhi signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 3 days ago
  • Mohammed signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 4 days ago
  • nemo3000 signed-up and became a member of the BrainSurface Oracle, Java & MySQL Communities ConnectSpace
    members 4 days ago
 

Who's Online?

1 user and 271 guests online

Quick Poll

Are you excited about the advent of VirtaThon?