Download General Reference - ALTIBASE Customer Support

3.2 Performance Views
which database recovery occurs due to the system suffering from a fault or for some other reason.
This column contains the unique LFG number, which is part of the RESET_LSN. It has the same value
as that in the LFG_ID column.
RESET_LSN_FILE_NO
RESET_LSN is the first LSN after the time point at which recovery was performed.
RESET_LSN_FILE_NO is the log file number portion of RESET_LSN.
RESET_LSN_OFFSET
This shows the offset within the log file, and is a portion of RESET_LSN.
UPDATE_TX_COUNT
This returns, in real time, the number of transactions in the LFG that are currently making changes to
the database.
GC_WAIT_COUNT
This shows the total number of times transactions in this LFG had to wait for disk I/O for group commit.
GC_ALREADY_SYNC_COUNT
During group commit, it is sometimes not necessary to perform disk I/O for some transactions,
because the logs containing them have already been written to disk. This is the cumulative number
of times this has occurred.
GC_REAL_SYNC_COUNT
This shows the number of actual disk I/O operations related to transactions in this LFG during group
commit.
3.2.31 V$LINKER_STATUS
This view shows the status of AltiLinker for Database Link.
Column name
Type
Description
LINKER_STATUS
INTEGER
Indicates the linker status. If it is 1, the linker
is in a normal state. If it is 0, the linker is in an
abnormal state, or is not available.
SESSION_COUNT
INTEGER
Indicates the number of Database Link sessions between ALTIBASE HDB and the linker.
335
The Data Dictionary