Overview/Description
identify the benefits of Oracle Database 11g's partitioning and storage-related enhancements, and recognize how to use SQL Access Advisor to help you optimize your database in this regard.
Target Audience
Oracle Database certified professionals who wish to upgrade to Oracle Database 11g certification; developers interested in the technical aspects of Oracle Database 11g; DBA's considering upgrading their systems to 11g
Prerequisites
The learner should have knowledge of Oracle Database 10g at least commensurate with that required to perform an administrator role
Oracle Database 11g: Partitioning and Storage-Related Enhancements
identify the steps for employing Oracle Database's new partitioning scheme to perform interval partitioning.
recognize the steps for performing system and virtual column-based partitioning, using Oracle Database 11g's new partitioning scheme.
identify the steps for performing reference partitioning, using Oracle Database 11g's new partitioning scheme.
recognize the steps for performing extended composite partitioning, using Oracle Database 11g's new partitioning scheme, and for compressing tables.
recognize the steps for using SQL Access Advisor to help you to decide which partitions, indexes, materialized views, and materialized view logs you need to optimize your database's workload.
use the SQL Access Advisor to get partitioning recommendations.