Solution : https://service.sap.com/sap/support/notes/619876 (SAP Service marketplace login required)
Key words :
- 'automatic pga tuning'- 'automatic sql execution memory management'- 'automatic pga memory management'- 'oracle managed pga', - hash join- bitmap merge join- bitmap create- bulk operations, sql>col sql_text format a80 wrapselect sql_text, simple pga memory tuning reduced administration work, sql>alter system set workarea_size_policy=auto, complete 'tuning pga automatic' process passes, sql>alter system set pga_aggregate_target=1024m, - workarea_size_policy- pga_aggregate_targetworkarea_size_policythe parameter workarea_size_policy controls, 'automatic pga tuning' solution support, oracle automatic pga memory management
Related Notes :
| 830576 | Parameter recommendations for Oracle 10g |
| 828268 | Oracle Database 10g: New functions |
| 806554 | FAQ: I/O-intensive database operations |
| 789011 | FAQ: Oracle memory areas |
| 758642 | ORA-00600 [qesmmCValStat4] on Oracle 9.2.0.5 |
| 725067 | Oracle 9i: KGH Heap Memory corruption |
| 712624 | High CPU consumption by Oracle |
| 598678 | Oracle 9i: New functions |
| 592393 | FAQ: Oracle |
| 502782 | Composite SAP Note ora-4030 |
| 335230 | ORA-4030 with NT and Business Information Warehouse |