SAP Knowledge Base Article - Preview

3017684 - High spinlock contention in Sysobject cache when execute LWP - SAP ASE

Symptom

  • High spinlock contention in sysobjects named cache when execute large number of dynamic light weigth procedure (LWP).
  • The sybmon sample output show many threads in a code path that contain the following functions:

    pausenonatomic
    lock_do_logical
    sdes_scan_setup
    lookup__sysobjects
    getobjrow
    getobjrow_byname
    lookup_object_with_protect
    s_normalize
    sequencer
    tdsrecv__dynexec
    tdsrecv_dynamic


Read more...

Environment

Adaptive Server Enterprise (ASE) 16 SP04

Adaptive Server Enterprise (ASE) 16 SP03 PL07

Adaptive Server Enterprise (ASE) 16 SP02 PL09

Adaptive Server Enterprise (ASE) 15.7 SP141

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

About this page

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

Search for additional results

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