Memory Management Methods
Instance | SGA | PGA | Description | Initialization Parameters |
Auto | n/a | n/a | The database tunes the size of the instance based on a single instance target size. | You set:
|
n/a | Auto | Auto | The database automatically tunes the SGA based on an SGA target. The database automatically tunes the PGA based on a PGA target. | You set:
|
n/a | Auto | Manual | The database automatically tunes the SGA based on an SGA target. You control the PGA manually, setting the maximum work area size for each type of SQL operator. | You set:
|
n/a | Manual | Auto | You control the SGA manually by setting individual component sizes. The database automatically tunes the PGA based on a PGA target. | You set:
|
n/a | Manual | Manual | You must manually configure SGA component sizes. You control the PGA manually, setting the maximum work area size for each type of SQL operator. | You must manually configure SGA component sizes. You set:
|