SAP Knowledge Base Article - Preview

2616215 - Resource->rproccache_spin spinlock contention in ASE 16.0 - SAP ASE

Symptom

When multiple inserts with similar values are happening on a table with column of numeric datatype:

  • Procedure cache can fill up
  • Spinlock contention on the statement cache can be observerd
  • The statement cache is full of duplicate statements
  • Contention in the rproccache_spin spinlock:

SpinlockName                          SlotID  Grabs     Spins             Waits   Contention   
-----------------------------------------------------------
SSQLCACHE_SPIN                  1407    177743  196843          4311    2.42
Resource->rproccache_spin   1401    12567    1223638074  12100  96.28


Read more...

Environment

SAP Adaptive Server Enterprse (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

CR#812309, CR#805165, cr812309, cr805165, dbcc, statement cache corruption, stored procedure, decimal, numeric, param, parameterized , 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.