Automatic SQL Plan Management
GPTKB entity
Statements (23)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
Database feature
|
| gptkbp:benefit |
Improved database stability
Predictable SQL performance Reduced risk during upgrades |
| gptkbp:canBe |
DBMS_SPM package
|
| https://www.w3.org/2000/01/rdf-schema#label |
Automatic SQL Plan Management
|
| gptkbp:introducedIn |
gptkb:Oracle_Database_11g
|
| gptkbp:managedBy |
DBA
|
| gptkbp:partOf |
gptkb:Oracle_Database
|
| gptkbp:prevention |
SQL performance regression
|
| gptkbp:purpose |
Ensures SQL statement performance stability
|
| gptkbp:relatedTo |
SQL Plan Management
SQL Plan Baseline Acceptance SQL Plan Baseline Capture SQL Plan Baseline Evolution SQL Tuning |
| gptkbp:storage |
Data Dictionary
|
| gptkbp:uses |
gptkb:SQL_Plan_Baselines
Plan Selection Plan Evolution SQL Plan History |
| gptkbp:bfsParent |
gptkb:Oracle_Database_19c
|
| gptkbp:bfsLayer |
8
|