total data cache size reports the amount of memory, in kilobytes, that is currently available for data, index, and log pages. This parameter is a calculated value that is not directly user-configurable.
Summary Information |
|
---|---|
Default value |
0 |
Range of values |
0 – 2147483647 |
Status |
Calculated |
Display level |
Basic |
Required role |
System administrator |
Configuration groups |
Cache Manager, Memory Use |
The amount of physical memory available on your machine
total logical memory
number of user connections
total procedure cache percent
number of open databases
number of open objects
number of open indexes
number of devices
A number of other parameters also affect the amount of available memory, but to a lesser extent.