SYSTEMLOCKS: Data Dictionary Locks
read only
- Catalog:
DataDictionary - Schema:
Invantive - Label: Locks
Locks.
Can only retrieve data.
Table Columns
The columns of the table SYSTEMLOCKS are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
ACQUISITION_ |
int64 |
Acquisition Count | Number of acquisitions. | ||
AVERAGE_ |
number |
Average Active | Average number of active slots. | ||
BILLING_ |
varchar2 |
Billing ID | ID for billing. | ||
BILLING_ |
varchar2 |
Billing ID Last Acquisition | ID for billing at last acquisition. | ||
BILLING_ |
varchar2 |
Billing ID Last Timeout | ID for billing at last timeout. | ||
CALLING_ |
varchar2 |
Calling Provider Alias | Calling provider alias. | ||
CATEGORY_ |
varchar2 |
Category Code | Category. | ||
CONTEXT |
varchar2 |
Context | Context. | ||
CURRENT_ |
int32 |
Current Free | Current capacity free. | ||
CURRENT_ |
int32 |
Current Read | Current read capacity used. | ||
CURRENT_ |
int32 |
Current Used | Current capacity used. | ||
CURRENT_ |
int32 |
Current Waiting | Current number of waiters. | ||
DATA_ |
varchar2 |
Data Container ID | Data container ID that created the lock. | ||
DATE_ |
datetime |
First Acquisition | Time of first acquisition. | ||
DATE_ |
datetime |
First Release | Time of first release. | ||
DATE_ |
datetime |
First Timeout | Time of first time-out. | ||
DATE_ |
datetime |
Last Acquisition | Time of last acquisition. | ||
DATE_ |
datetime |
Last Full Release | Time of last full release. | ||
DATE_ |
datetime |
Last Operation | Time of last operation. | ||
DATE_ |
datetime |
Last Release | Time of last release. | ||
DATE_ |
datetime |
Last Timeout | Time of last time-out. | ||
DATE_ |
datetime |
Registered | Time of registration. | ||
EXECUTION_ |
int64 |
SQL Execution Step ID | ID of the SQL execution step that created the lock. | ||
GUI_ |
varchar2 |
GUI Action | Action performed within the user interface. | ||
GUI_ |
varchar2 |
GUI External IP Address | External IP address of the GUI application. | ||
GUI_ |
varchar2 |
GUI IP Address External Last Acquisition | External IP address of the GUI application at last acquisition. | ||
GUI_ |
varchar2 |
GUI IP Address External Last Timeout | External IP address of the GUI application at last timeout. | ||
GUI_ |
uint16 |
GUI IP Port | External IP port of the GUI application. | ||
GUI_ |
uint16 |
GUI IP Port Last Acquisition | External IP port of the GUI application at last acquisition. | ||
GUI_ |
uint16 |
GUI IP Port Last Timeout | External IP port of the GUI application at last timeout. | ||
GUI_ |
varchar2 |
GUI Machine | Name of the machine running the GUI application. | ||
GUI_ |
varchar2 |
GUI Module Name | Module within the GUI application currently running. | ||
GUI_ |
varchar2 |
GUI Module Version | Version of module within the GUI application currently running. | ||
GUI_ |
varchar2 |
GUI OS User | OS user. | ||
GUI_ |
varchar2 |
User | Application user. | ||
INITIAL_ |
int32 |
Initial Capacity | Initial capacity. | ||
LAST_ |
varchar |
Acquisition Category Code | Category code of last acquisition. | ||
LAST_ |
varchar |
Full Release Category Code | Category code of last full release. | ||
LAST_ |
varchar |
Operation Category Code | Category code of last operation. | ||
LAST_ |
varchar |
Release Category Code | Category code of last release. | ||
LAST_ |
varchar |
Timeout Category Code | Category code of last timeout. | ||
LAST_ |
double |
Last Wait Timeout (ms) | Time-out in milliseconds of last started and active wait. | ||
MAXIMUM_ |
int32 |
Maximum Capacity | Maximum capacity. | ||
PARTITION_ |
varchar2 |
Partition Code | Unique code of the partition that created the lock. | ||
POOL_ |
varchar2 |
Pool Identity | Pool identity. | ||
POOL_ |
varchar2 |
Pool Identity Last Acquisition | Pool identity at last acquisition. | ||
POOL_ |
varchar2 |
Pool Identity Last Timeout | Pool identity at last timeout. | ||
PROCESS_ |
uint32 |
Process ID | Process ID. | ||
PROVIDER_ |
varchar2 |
Provider Name | Name of the provider that created the lock. | ||
RELEASE_ |
int64 |
Release Count | Number of releases. | ||
REQUEST_ |
varchar2 |
Request ID | Request ID. | ||
REQUEST_ |
varchar2 |
Request ID Last Acquisition | Request ID at last acquisition. | ||
REQUEST_ |
varchar2 |
Request ID Last Timeout | Request ID at last timeout. | ||
SESSION_ |
varchar2 |
Session ID | ID of the session that created the lock. | ||
SQL_ |
varchar2 |
SQL Statement | SQL statement that created the lock. | ||
STDDEV_ |
number |
Standard Deviation Active | Standard deviation number of active slots. | ||
STYLE |
varchar |
Style | Style. | ||
TABLE_ |
varchar2 |
Table Name | Name of the table that created the lock. | ||
TIMEOUT_ |
int64 |
Timeout Count | Number of timeouts. | ||
TYPE |
varchar2 |
Type | Type of lock. One of: SEMAPHORE or RWLOCK. | ||
UID |
guid |
UID | Unique ID. | ||
WAITS_ |
int64 |
Waits Completed | Number of waits completed. | ||
WAIT_ |
double |
Average Wait Duration (ms) | Average duration of wait (ms)). | ||
WAIT_ |
double |
Standard Deviation Wait Duration (ms) | Standard deviation duration of wait (ms)). |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: