Solution : https://service.sap.com/sap/support/notes/789011 (SAP Service marketplace login required)
Summary :
This SAP Note addresses various aspects of Oracle memory management, key for optimal performance and system stability. It identifies and describes different Oracle memory areas including the System Global Area (SGA) and the Program Global Area (PGA), detailing their purposes and components such as the Buffer Pool, Shared Pool, and Redo Buffer. The note outlines important parameters influencing memory sizes, including `DB_CACHE_SIZE` and `SGA_TARGET`, and advises on setting these parameters within an SAP environment to prevent common issues like inadequate memory allocation and unintended resizing activities. Additionally, it covers methods to investigate current memory utilization and adjust sizes based on system demands.
Key words :
oracle memory = buffer pool + shared pool + pga + process memory due, internal limit restriction exceeded error ora-12540, fewer time-consuming disk-accesses, 6 mb operating system-sided memory consumption, frequently asked questions solution 1, large buffer pools due, single operating system process, separate operating system process, process allocates 5 mb memory, pga allocation primarily depends
Related Notes :
| 1266245 | V$PGASTAT - more memory allocated than specified |
| 1034126 | ORA-00832 when using Oracle Data Pump |
| 1028099 | Long import runtimes for large db_cache_size |
| 1013049 | FAQ: Oracle Data Pump |
| 896006 | Fixes for reading order of Employer Tip Allocation (8027) |
| 875477 | Avoiding long runtimes with BEGIN BACKUP |
| 832343 | FAQ: Clustering factor |
| 830576 | Parameter recommendations for Oracle 10g |
| 825653 | Oracle: Common misconceptions |
| 806554 | FAQ: I/O-intensive database operations |
| 804186 | sga size > 2GB on Linux |
| 776021 | Incorrect shared pool size in ST04 |
| 771929 | FAQ: Index fragmentation |
| 767414 | FAQ: Oracle latches |
| 750631 | Approximations for cost calculation of the CBO |
| 750205 | High memory usage with AIX5.2/5.3 and Oracle9.2 |
| 743328 | Composite SAP note: ORA-27102 |
| 723744 | WARNING: EINVAL creating segment of size <size> |
| 712624 | High CPU consumption by Oracle |
| 690241 | The Shared SQL Area in the Shared Pool and large SQL Stmnts |
| 651060 | FAQ: Oracle Parallel Execution |
| 632556 | Oracle 9.2.0.* database parameterization for BW |
| 619876 | Oracle9i: Automatic PGA Memory Management |
| 619188 | FAQ: Oracle wait events |
| 618868 | FAQ: Oracle performance |
| 617416 | Oracle9i: Dynamic SGA |
| 541695 | ORA-00470/ORA-00471/ORA-00472/ORA-00473/ORA-00474 |
| 502782 | Composite SAP Note ora-4030 |
| 441663 | USING > 3 GB of memory for Oracle on WINDOWS platforms |
| 142019 | 3GB Memory and Oracle 8 on Windows (NT or 2000) |
| 133351 | Short dumps due to Oracle error ORA 4031 |
| 130140 | ORA-4030 on NT, out of process memory |
| 128221 | Increased memory consumption with Oracle >8.0.X |
| 105047 | Support for Oracle functions in the SAP environment |
| 101717 | Automatic restart of SAP R/3 work processes |
| 70197 | Is Multi-Threaded Server supported with SAP |