What is PGA_AGGREGATE_TARGET?
Submitted by: AdministratorThis parameter controls the maximum amount of memory PGA which can be used by the queries when WORKAREA_SIZE_POLICY is set to Auto.
The value you can be set in Bytes, kilobytes (K), megabytes (M) or gigabytes (G). The default value is 0
This parameter also has an effect on the execution plans of the cost based optimizer. The optimizer uses the value of the parameter PGA_AGGREGATE_TARGET to derive an estimate
for the minimum and maximum amount of memory which should be available at run-time for each sort, hash-join and bitmap operator in the query. Based on this minimum and maximum value, the
optimizer selects the best plan.
Submitted by: Administrator
The value you can be set in Bytes, kilobytes (K), megabytes (M) or gigabytes (G). The default value is 0
This parameter also has an effect on the execution plans of the cost based optimizer. The optimizer uses the value of the parameter PGA_AGGREGATE_TARGET to derive an estimate
for the minimum and maximum amount of memory which should be available at run-time for each sort, hash-join and bitmap operator in the query. Based on this minimum and maximum value, the
optimizer selects the best plan.
Submitted by: Administrator
Read Online Oracle DBA Job Interview Questions And Answers
Top Oracle DBA Questions
☺ | What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other? |
☺ | When using Oracle export/import what character set concerns might come up? How do you handle them? |
☺ | Explain FORCE LOGGING feature in 9i. |
☺ | Name three SQL operations that perform a SORT. |
☺ | What is the difference between RAID 5 and RAID 10? Which is better for Oracle? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Forms Reports Interview Questions. |