Summary information |
|
|---|---|
Default value |
0 |
Range of values |
0–1 |
Status |
Dynamic |
Display level |
Comprehensive |
Required role |
System Administrator |
abstract plan cache enables caching of abstract plan hash keys. By default, caching is not enabled. For more information, see Chapter 16, “Creating and Using Abstract Plans” in Performance and Tuning: Optimizer and Abstract Plans. abstract plan load must be enabled in order for plan caching to take affect.
