Solution : https://service.sap.com/sap/support/notes/617416 (SAP Service marketplace login required)
Key words :
sql>show sgatotal system global area 135339268 bytesfixed size 453892 bytesvariable size 109051904 bytesdatabase buffers 25165824 bytesredo buffers 667648 bytessql>, sql>show parameter db_block_buffers sql>show parameter buffer_pool_keep sql>show parameter buffer_pool_recyclenew parameters, sql>show parameter sga_max_size sql>show parameter cache_size sql>show parameter statistics_level2, sql>show parameter db_block_buffers sql>show parameter buffer_pool_keep sql>show parameter buffer_pool_recyclethe, current settings sql>show sga sql>show parameter db_block_sizeold parameters, sql>show parameter buffer_pool_keep sql>show parameter buffer_pool_recycle set, sga parameter sql>alter system reset buffer_pool_keep scope = spfile sid=' ', sysdba sql>shutdown sql>startup sql>show sgathe, sql>show parameter sga_max_size sql>show parameter db_cache_sizethe, typical sql>alter system set statistics_level='typical' scope = spfile
Related Notes :
| 939558 | ORA-600 during dynamic change of System Global Area (SGA) |
| 830576 | Parameter recommendations for Oracle 10g |
| 789011 | FAQ: Oracle memory areas |
| 743328 | Composite SAP note: ORA-27102 |
| 712624 | High CPU consumption by Oracle |
| 598678 | Oracle 9i: New functions |
| 592393 | FAQ: Oracle |
| 579540 | ORA-00381, unable to start the Oracle 9.x database |
| 550585 | SAP relevant patches for Solaris 9 on SPARC |
| 360438 | SAP relevant patches for Solaris 8 on SPARC |