AE_TEMPLOCK_VW

index back

Temp Tbl Lock by Table

Tracks how many Locks are currently in effect for a particular Temporary Table.
SELECT RECNAME , COUNT(*) FROM PS_AETEMPTBLMGR WHERE CURTEMPINSTANCE > 0 GROUP BY RECNAME

PeopleSoft Field NameField TypeColumn TypeDescription
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
TEMPTBLINSTLOCKSNumber(4,0)SMALLINT NOT NULLUsed to track how many instances of a particular temporary table are locked/in use at the moment.
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19