Performance Tuning
SQL Access Advisor
User Rating: / 1
- Details
-
Parent Category: Articles
-
Created on Thursday, 18 March 2010 22:15
-
Last Updated on Monday, 12 March 2012 13:54
-
Published on Thursday, 18 March 2010 22:15
-
Written by Guy Lambregts
-
Hits: 4586
SQL Access Advisor
ARTICLE TO BE REVIEWED AND COMPLETED
Note you need an additional licence in order to use the SQL Access Advisor
You can use the SQL Access Advisor through the GUI Oracle Enterprise Manager or through the command line ( DBMS_ADVISOR ). Using the SQL Tuning through the command line can become complicated so the preferred tool is the GUI.
The SQL Access Advisor is an 10G utility - a built in engine - to analyse the access path and to advice database design improvements.
INPUT
1. The input source is a SQL statement or a SQL Tuning Set ( STS )
2. A possible additional input for the SQL Access are Workloads which can be partial or full. The purpose of the workload is obviously to feed the SQL Access Advisor with the appropriate database (work)load statistics. Hence the recommendations - which is the output of the SQL Access Advisor - can be based on this (work)load.
The Workload itself can have the below listed input sources
1. A SQL Tuning Set ( STS )
2. A user workload which "picks" the workload data up from a table. This table has a specific structure.
3. The actual SQL Cache
4. A hypothetical workload defined on dimensions
EXECUTION
OUTPUT