We were told that the database does not have default settings. Self Tuning Memory needs to be turned on, and to make sure that there are no limits on pools and tables.
DBA tuned on the Self Tuning memory parameter to ON (it was off) and also found that the default buffer pool was not set to Automatic. The default buffer pool size was then set to automatic.
Other than that, we are not sure what other tables and pools we need to check to make sure that they are not being limited. This is part of support response:
"When your DBA sets the parameter to OFF and limited pools, he affected not only the single parameter, he also set limitations for a number of BFI tables (couldn’t do this with the parameter set to ON). Therefore setting back the parameter to ON for self tuning memory is not enough, DBA should also set the default values for all BFI’s tables he modified before.
It is good that you switch on the automatic configuration, but you still need to set the BFI tables parameters to default configuration to stop limiting pools."
… It is not clear what we need to look for.