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 Name Field Type Column Type Description
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
TEMPTBLINSTLOCKS Number(4,0) SMALLINT NOT NULL Used 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.uk PeopleTools 8.54
PTRef generated on 09-JUN-19