Solution : https://service.sap.com/sap/support/notes/41360 (SAP Service marketplace login required)
Key words :
34 2 4bufwaits lokwaits lockreqs deadlks dltouts ckpwaits compress seqscans`ixda-ra idx-ra da-ra ra-pgsused lchwaits203581 44 16716 216866 5366, 48isamtot open start read write rewrite delete commit4903836 41349 124207 4009531 48295 3392 2526 2008ovlock ovuserthread ovbuff usercpu syscpu numckpts flushes0 0 0 1101, logical loggingbuffer bufused bufsize numrecs numpages numwrits recs/pages pages/io l-1 0 8 5898609 898878 358944 6, fg writes lru writes chunk writes0 263094 73191address flusher state datad3292450 0, profiles dskreads pagreads bufreads %cached dskwrits pagwrits bufwrits %cached273827 275485 9778436 97, physical loggingbuffer bufused bufsize numpages numwrits pages/io p-2 759 768 276464 371 745, totalops dskread dskwrite dskcopy wakeups io/wup msc 0, totalops dskread dskwrite dskcopy wakeups io/wup aio 0, vp pid class usercpu syscpu total 1 20150 cpu 75955, -> max_pdqpriority-> ds_max_queries-> ds_total_memory-> ds_max_scans-> dataskip max_pdqpriority installed
Related Notes :
| 1273931 | Performance improvement when system load is high |
| 1127881 | Poor performance due to mutex hash wait DS cache |
| 407543 | AIX: Shared Memory Management with Informix |
| 146155 | Installation: NUMCPUVPS ... is not adjusted |
| 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) |
| 95094 | Increase size of physical log inside 'physdbs' |
| 76583 | Shared memory: Error when creating a segment |
| 71776 | INFCFGCHECK: Automatic database checks |
| 64987 | Message 16652 not found |
| 64001 | INFCFGCHECK: Detailed messages of single checks |
| 63256 | Database on multiprocessor with NOAGE=1 |
| 53050 | Resetting of SAP Statement Cache |
| 49381 | Configuration of temporary dbspaces |
| 44591 | You cannot create new chunks |
| 38307 | Reducing shared memory consumption |
| 29413 | Extending the logical log |
| 23320 | oninit: "Fatal error in initializing ASF..." |