All databases
systhresholds contains one row for each threshold defined for the database.
The columns for systhresholds are:
Name |
Datatype |
Description |
|---|---|---|
segment |
smallint |
Segment number for which free space is being monitored. |
free_space |
int |
Size of threshold, in 2K pages (4K for Status). |
status |
smallint |
Bit 1 equals 1 for the logsegment’s last-chance threshold, 0 for all other thresholds. |
proc_name |
varchar(255) |
Name of the procedure that is executed when the number of unused pages on segment falls below free_space. |
suid |
int |
The server user ID of the user who added the threshold or modified it most recently. |
currauth |
varbinary(255) |
A bit mask that indicates which roles were active for suid at the time the threshold was added or most recently modified. When the threshold is crossed, proc_name executes with this set of roles, less any that have been deactivated since the threshold was added or last modified. |
