invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

SYSTEMPSQLLOCKS: Data Dictionary PSQL Locks

read only

  • Catalogue : DataDictionary
  • Schéma : Invantive
  • Label: PSQL Locks

Named PSQL locks of the session (dbms_lock). Fully released locks stay listed with their lifetime statistics, bounded to the 10,000 most recently released; locks currently held or waited on are always listed.

Permet uniquement de récupérer des données.

Colonnes de table

Les colonnes de la table SYSTEMPSQLLOCKS sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.

Name Type de données Label Required Marks Documentation
FIRST_ACQUIRED_UTC datetime Date de la première acquisition (UTC) Moment the lock was first acquired since the session created it.Lifetime statistic: a release does not clear it.
FIRST_WAITER_UTC datetime Premier serveur (UTC) Moment a frame first started waiting on the lock.Lifetime statistic.
HOLDER_DESCRIPTION varchar2 Holder Description of the worker frame holding the lock: a parallel branch, a parallel loop worker or the main frame.Empty when free.
HOLD_COUNT int32 Nombre de retenues Re-entrant hold count of the holding frame.
LAST_ACQUIRED_UTC datetime Dernière acquisition (UTC) Moment the lock was most recently acquired (hold count zero to one).Lifetime statistic: a release does not clear it.
LAST_WAITER_UTC datetime Dernier serveur (UTC) Moment a frame most recently started waiting on the lock.Lifetime statistic.
NAME varchar2 Name Name of the PSQL lock (dbms_lock).
WAITER_COUNT int32 Nombre de serveurs Number of frames currently waiting on the lock.

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :