SQL Access Advisor

GPTKB entity

Statements (18)
Predicate Object
gptkbp:instanceOf gptkb:software
gptkbp:accessibleBy gptkb:Oracle_Enterprise_Manager
DBMS_ADVISOR package
gptkbp:category database administration
gptkbp:developedBy gptkb:Oracle_Corporation
gptkbp:documentation https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/tuning-sql-access-advisor.html
https://www.w3.org/2000/01/rdf-schema#label SQL Access Advisor
gptkbp:introducedIn gptkb:Oracle_Database_10g
gptkbp:partOf gptkb:Oracle_Database
gptkbp:purpose SQL tuning
index recommendation
materialized view recommendation
partitioning recommendation
gptkbp:supports workload analysis
SQL performance optimization
gptkbp:bfsParent gptkb:Oracle_Database_10g_Release_2
gptkb:Oracle_11g
gptkbp:bfsLayer 8