| STATISTICS_LEVEL |
BASIC |
TYPICAL |
ALL |
| DB_CACHE_ADVICE |
OFF |
ON |
ON |
2.352 STATISTICS_LEVEL
| Property |
Description |
| Syntax |
STATISTICS_LEVEL = { ALL |
| Default value |
TYPICAL |
When the STATISTICS_LEVEL parameter is set to ALL, additional statistics are added to the set of statistics collected with the TYPICAL setting. The additional statistics are timed operating system statistics and plan execution statistics.
2.76 DB_CACHE_ADVICE
| Property |
Description |
| Default value |
If STATISTICS_LEVEL is set to TYPICAL or ALL, then ON
If STATISTICS_LEVEL is set to BASIC, then OFF |