My Oracle Support Banner

Oracle12C: Using SQLAccess Advisor (DBMS_ADVISOR) -- Partition Advisor (Doc ID 1567962.1)

Last updated on OCTOBER 18, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

Purpose

 This article is a step by step demonstration on how to use the Oracle12c SQLAccess Advisor (DBMS_ADVISOR) package to get recommendations about how partitioning 
can improve performance.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Purpose
Details
 Prepare the SH sample schema for using SQLAccess Advisor PL/SQL API.
 Create the Workload to be processed by SQLAccess Advisor by creating a SQL Tuning Set and populating it with the queries generated previously.
  Create a template to be used for partitioning
 Process the Workload using SQLAccess Advisor by creating and executing a Tuning Task.
 
Review the generated recommendations and get them in SQL script form.
 Implement the recommendations by executing the script generated.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.