SYSTEMPSQLLOCKS: Data Dictionary PSQL Locks
read only
- Catálogo:
DataDictionary - Esquema:
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.
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla SYSTEMPSQLLOCKS. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
FIRST_ |
datetime |
Fecha de la primera adquisición (UTC) | Moment the lock was first acquired since the session created it.Lifetime statistic: a release does not clear it. | ||
FIRST_ |
datetime |
Primer camarero (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 |
Recuento de retenciones | Re-entrant hold count of the holding frame. | ||
LAST_ |
datetime |
Última adquisición (UTC) | Moment the lock was most recently acquired (hold count zero to one).Lifetime statistic: a release does not clear it. | ||
LAST_ |
datetime |
Último camarero (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 |
Número de camareros | Number of frames currently waiting on the lock. |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: