SAP Knowledge Base Article - Preview

2140694 - After upgrading to ASE 15.7, it takes long to insert text/image to large table and causes high CPU - SAP ASE

Symptom

  • Insert text/image data to large tables runs fine in ASE 15.5.  
  • The same process runs slowly after upgrading to ASE 15.7
  • The same process in ASE 15.7 causes high CPU usage.
  • The text/image insert process shows the status in 'latch sleep' on ASE 15.7
  • From DBCC STACKTRACE output, the text/image insert process references the following modules:

pg__nextnonzeroentry()
pg__allocate_from_oamscan()
_$o1cezdP0.pg__allocate()
pg_allocate()
alloctext()
text_handler()
inserttext()
instext()


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 and up
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

KBA , oam page , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.