Solution : https://service.sap.com/sap/support/notes/789011 (Connexion à SAP Service Marketplace requise)
Résumé :
Cette note SAP traite des différents aspects de la gestion de la mémoire Oracle, essentiels pour une performance optimale et la stabilité du système. Elle identifie et décrit les différentes zones de mémoire Oracle, notamment la System Global Area (SGA) et la Program Global Area (PGA), détaillant leurs objectifs et composants tels que le Buffer Pool, le Shared Pool et le Redo Buffer. La note précise les paramètres importants influençant les tailles de mémoire, notamment `DB_CACHE_SIZE` et `SGA_TARGET`, et conseille sur la configuration de ces paramètres dans un environnement SAP pour prévenir des problèmes communs comme l'allocation de mémoire insuffisante et les activités de redimensionnement involontaires. De plus, elle couvre les méthodes pour enquêter sur l'utilisation actuelle de la mémoire et ajuster les tailles en fonction des besoins du système.
Mots Clés :
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
Notes associées :
| 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 |