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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview