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.