SAP Note 38307 - Reducing shared memory consumption

Composant : Informix - Database Administration with Informix

Solution : https://service.sap.com/sap/support/notes/38307 (Connexion à SAP Service Marketplace requise)

Mots Clés :
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

Notes associées :

171026Informix sessions use to much shared memory
110513Shared memory usage extremely high without reason
103747Performance: Parameter recommendations as of Release 4.0
101717Automatic restart of SAP R/3 work processes
97497Memory Management Parameter (3.0/3.1)
94556mt_shm_init: can't create resident segment
76583Shared memory: Error when creating a segment
64001INFCFGCHECK: Detailed messages of single checks
53050Resetting of SAP Statement Cache
47554SNI: INFORMIXSHMBASE
44779SQL error "INF-394: View view-name not found."
41360Database configuration using onconfig parameter
18993Influence of LOCK Parameter on Shared Memory Size
16038Assert Failed: Internal error - segmentation viol.