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_ |
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_ |
datetime |
Premier serveur (UTC) | Moment a frame first started waiting on the lock.Lifetime statistic. | ||
HOLDER_ |
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_ |
int32 |
Nombre de retenues | Re-entrant hold count of the holding frame. | ||
LAST_ |
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_ |
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_ |
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 :