Solution : https://service.sap.com/sap/support/notes/38307 (SAP Service marketplace login required)
Key words :
ses session #rsam total usedid user tty pid hostname threads memory memory15662 sapr3 - 4361 host_1 1 4628480 461959215209 sapr3 - 27659 host_1 1 6512640 649440014854 sapr3 - 24924 host_1 1 14352384 1304723214370 sapr3 - 18013 host_1 1 17055744 1682325610163 sapr3 - 18018 host_1 1 4308992 42863929631 sapr3 - 9582 host_1 1 7241728 7194040179 sapr3 - 5886 host_1 1 1826816 1820136178 sapr3 - 5883 host_2 1 5881856 5857864177 sapr3 - 5887 host_2 1 483328 475176176 sapr3 - 5884 host_2 1 5808128 5781552174 sapr3 - 5875 host_2 1 4268032 4210808170 sapr3 - 5885 host_3 1 3702784 3697048169 sapr3 - 5880 host_3 1 13500416 13350448168 sapr3 - 5882 host_3 1 7585792 7210728the column, shorten output]541 32768 7338 22 2328 7 sqlexec542 32768 8490 25 2328 7 sqlexec543 32768 24242 73 2344 7 sqlexec544 32768 7298 22 2288 6 sqlexec545 32768 7338 22 2328 7 sqlexec546 32768 21609 65 2304 7 sqlexec547 32768 8402 25 2304 7 sqlexec548 32768 8554 26 2328 7 sqlexec549 32768 8410 25 2312 7 sqlexecin, application servers host_1, resident portion message portion virtual portiona, tid total max current thread, column 'max bytes', sqlexec threads deleted, set /dbs/inf/free_cursor_on =true rel, user <sid>adm/ informix, total memory
Related Notes :
| 171026 | Informix sessions use to much shared memory |
| 110513 | Shared memory usage extremely high without reason |
| 103747 | Performance: Parameter recommendations as of Release 4.0 |
| 101717 | Automatic restart of SAP R/3 work processes |
| 97497 | Memory Management Parameter (3.0/3.1) |
| 94556 | mt_shm_init: can't create resident segment |
| 76583 | Shared memory: Error when creating a segment |
| 64001 | INFCFGCHECK: Detailed messages of single checks |
| 53050 | Resetting of SAP Statement Cache |
| 47554 | SNI: INFORMIXSHMBASE |
| 44779 | SQL error "INF-394: View view-name not found." |
| 41360 | Database configuration using onconfig parameter |
| 18993 | Influence of LOCK Parameter on Shared Memory Size |
| 16038 | Assert Failed: Internal error - segmentation viol. |