What's New in Oracle Database to Support Very Large Databases?

This chapter describes new features in Oracle Database to support very large databases (VLDB).

Oracle Database 11g Release 2 (11.2.0.2) New Features to Support Very Large Databases

These are the new features in Oracle Database 11g Release 2 (11.2.0.2) to support very large databases:

• Enhancements for managing segments

  • Segment creation on demand for partitioned tables

    This feature enables the creation of partitioned tables with deferred segment creation. With this feature, on-disk segments are not created for a subpartition and its dependent objects until the first row is inserted.

    For information about partitioning, refer to "Using Partitioning with Segments".

  • Enhanced TRUNCATE functionality

    If a partition or subpartition has a segment, the truncate feature drops the segment if the DROP ALL STORAGE clause is specified.

    For information about partitioning, refer to "Using Partitioning with Segments".

  • Maintenance package for segment creation on demand

    New procedures are added to the PL/SQL DBMS_SPACE_ADMIN package to enable you to maintain segment creation on demand.

    For information about partitioning, refer to "Using Partitioning with Segments".

• Managing Parallel Statement Queuing

  By default, parallel statements are dequeued from the parallel statement queue in a simple first in, first out (FIFO) order. This feature enables you to use resource manager to manage the parallel statement queue by configuring a resource plan that controls the order in which parallel statements are dequeued. For example, you can ensure that parallel statements associated with a high-priority workload or consumer group are dequeued ahead of parallel statements from low-priority consumer groups. Alternatively, you could implement a fair-share policy that dequeues parallel statements based on the resource allocations configured for each consumer group.

  For information about parallel statement queuing, refer to "Parallel Statement Queuing". For information about managing parallel statement queuing, refer to "Managing Parallel Statement Queuing with Resource Manager".

  See Also:

  • Oracle Database Concepts for information about parallel query processing

  • Oracle Database SQL Language Reference for information about the PARALLEL hint

  • Oracle Database PL/SQL Packages and Types Reference for information about the DBMS_RESOURCE_MANAGER package