The System Cache core uses instantiated block RAM or UltraRAM; how many varies with configuration. Distributed RAM is inferred by the RTL code and is also dependent on the configuration.
For full details about performance and resource use, visit the Performance and Resource Use web page.