Resource limits defined by a system administrator to regulate server resources
None
| Name | Data Type | Description |
|---|---|---|
| NAME | string(32) | Login name that is the target of the resource limit, if applicable |
| APPNAME | string(32) | Application name that is the target of the resource limit, if applicable |
| RANGENAME | string(256) | Name of the time range to use; see TIME_RANGE |
| RANGEID | long | ID of the time range to use; see TIME_RANGE |
| LIMITID | long | ID of resource to limit |
| LIMITVALUE | long | Value to use as the limit on the resource |
| ENFORCED | long | ID of the type of enforcement of the limit |
| ACTION | long | ID of the action to take upon violating the limit |
| SCOPE | long | Mask of scopes in which to apply the limit |
| ENFORCED_DESC | string(32) | Type of enforcement of the limit (prior to exec, during exec, before and during exec, unknown) |
| ACTION_DESC | string(32) | Action to take upon violating the limit (issue warning, abort query batch, abort transaction, kill session, unknown) |
| SCOPE_DESC | string(32) | Scopes in which to apply the limit (query, query batch, transaction, query batch and transaction, unknown) |
| LIMIT_TYPE | string(32) | Type of resource limit, including (varies by ASE version) but not limited to:
|
| Attributes: | None |
|---|---|
| Minimum database version: | 12.5.0.3 |