2169121 - What are columns OwnerPID and LastOwnerPID in monSpinlockActivity? - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2169121 - What are columns OwnerPID and LastOwnerPID in monSpinlockActivity? - SAP ASE

Symptom

  • Selecting data from MDA repository for monSpinlockActivity 
  • What is the meaning of the columns OwnerPID and LastOwnerPID?

select * from monSpinlockActivity where SpinlockName = "default data cache"
go

  Grabs                  Spins        Waits       OwnerPID    LastOwnerPID     Contention   InstanceID   SpinlockName                                                         
-------------------- ------------ ---------   -----------   ------------          ------------   ----------      ------------------
  300488                5704        35           0                3604508            0.000116       0               default data cache                                                  
(1 row affected)

select * from monSpinlockActivity where SpinlockName = "default data cache"
go

 Grabs                Spins                Waits                OwnerPID    LastOwnerPID Contention   InstanceID   SpinlockName

-------------------- -------------------- -------------------- ----------- ------------ ------------- ---------- -------------------

312381                 5704                   35           0      3735581          0.000112          0         default data cache

(1 row affected)


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) All Versions

Product

SAP Adaptive Server Enterprise all versions

Keywords

KBA , monitor table , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

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.