Statements (41)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
gptkb:database
|
| gptkbp:canBe |
SQL patches
SQL profiles adaptive plans |
| gptkbp:canBeAcceptedBy |
DBMS_SPM.ACCEPT_SQL_PLAN_BASELINE
|
| gptkbp:canBeDisabled |
true
|
| gptkbp:canBeEvolvedBy |
DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE
|
| gptkbp:canBeNonFixed |
true
|
| gptkbp:canCreate |
manual loading
DBMS_SPM package automatic plan capture |
| gptkbp:canDrop |
DBMS_SPM.DROP_SQL_PLAN_BASELINE
|
| gptkbp:canImport |
gptkb:Data_Pump
|
| gptkbp:documentation |
Oracle Database Performance Tuning Guide
Oracle Database SQL Tuning Guide |
| gptkbp:enables |
plan evolution
plan history plan selection control |
| gptkbp:exportedTo |
gptkb:Data_Pump
|
| gptkbp:fixes |
true
|
| gptkbp:hasFeature |
true
|
| https://www.w3.org/2000/01/rdf-schema#label |
SQL Plan Baselines
|
| gptkbp:introducedIn |
gptkb:Oracle_Database_11g
|
| gptkbp:managedBy |
DBA
|
| gptkbp:partOf |
gptkb:Oracle_Database
|
| gptkbp:purpose |
stabilize SQL execution plans
|
| gptkbp:relatedTo |
SQL Plan Management
SQL tuning SQL performance |
| gptkbp:requires |
licensed Oracle Database
|
| gptkbp:storage |
gptkb:dictionary
|
| gptkbp:type |
baseline
SQL plan |
| gptkbp:usedFor |
plan management
performance stability preventing plan regressions |
| gptkbp:viewedBy |
DBA_SQL_MANAGEMENT_CONFIG
DBA_SQL_PLAN_BASELINES DBA_SQL_PLAN_HISTORY |
| gptkbp:bfsParent |
gptkb:Oracle_Database_10g_Release_2
|
| gptkbp:bfsLayer |
8
|