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:
|
相关推荐
**Description:** Improved tablespace management features in Oracle 10g simplify the administration of tablespaces. This includes automatic tablespace extension and reclamation of free space, making it...
The software developer looking for powerful, flexible protection, license management tools to get your software product into the hands of customers IceLicense supports all the latest data security ...
aware visual controls such as QuickReport, DBGrid, DBNavigator, DBImage, DBMemo, DBRichEdit and others Calculated and lookup fields Most of TTable functions including Key and Range methods Support for...
You can also view the system information that has been retrieved—such as CPU, memory, and processes running on the machine—and an image of the machine executing the system test. 6、测试用例设计、...